Link between PO_HEADERS_ALL AND AP_INVOICES_ALL tables

PO_DISTRIBUTIONS_ALL. PO_DISTRIBUTION_ID = AP_INVOICE_DISTRIBUTIONS_ALL. PO_DISTRIBUTION_ID

PO_VENDORS. VENDOR_ID = AP_INVOICES_ALL. VENDOR_ID

Link between OE_ORDER_HEADERS_ALL and RA_CUSTOMER_TRX_ALL

RA_CUSTOMER_TRX_ALL will have header information

INTERFACE_HEADER_CONTEXT                      =          ‘ORDER ENTRY’

INTERFACE_HEADER_ATTRIBUTE1                  =          order_number

RA_CUSTOMER_TRX_LINES_ALL will have invoice lines

INTERFACE_LINE_CONTEXT                             =          ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1             =          order_number

INTERFACE_LINE_ATTRIBUTE6             =          line_id from oe_order_lines_all

INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries

RA_INTERFACE_LINES_ALL will have invoice lines

INTERFACE_LINE_CONTEXT                             =          ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1             =          order_number

INTERFACE_LINE_ATTRIBUTE3             =          delivery_id from wsh_new_deliveries

Difference between back to back order and drop ship order

Drop shipment is similar to this back to back process in that your sales order. Line creates a requisition line that becomes a po sent to your supplier. In a drop shipment however you instruct your supplier to send the item or configured item directly to your customer. The item never physically pass through your warehouse & therefore you do not pick, pack or ship them yourselves. In the back to back scenario, you instruct your supplier to send you the goods and then you ship them on to your customer.

line status during the sales order process?

Entering the sales order                         Entered

Booking the sales order                         Awaiting shipping (when sufficient quantity is available)

Supply eligible (when sufficient quantity is not available)

Pick release the order                          Picked

Ship confirm the order                          Shipped

Running interface trip stop                    Closed

Header status during the sales order process?

Entering the sales order                         Entered

Booking the sales order                         Booked

Pick release the order                            Booked

Ship confirm the order                           Booked

Running interface trip stop                     Booked

How to set ORG_ID in11i?

Begin

FND_CLIENT_INFO.SET_ORG_CONTEXT(204);

end;

begin

dbms_application_info.set_client_info(103);

end;

How to set ORG_ID in R12?

By using mo_global.set_policy_context
mo_global.set_policy_context has two parameters p_access_mode & p_org_id

p_access_mode:
S In case you want your current session to work against Single ORG_ID
M In case you want your current session to work against multiple ORG_IDs

p_org_id: Only applicable if p_access_mode is passed value of "S"

Syntax:
Begin
mo_global.set_policy_context(‘S’, &org_id);
End;

e.g.

Begin
mo_global.set_policy_context(‘S’, 103);

End;