DBA Data[Home] [Help]

APPS.WMS_WMSSTCON_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 123: OE_ORDER_HEADERS_ALL

119: SELECT
120: ORDER_NUMBER
121: INTO P_SALES_ORDER
122: FROM
123: OE_ORDER_HEADERS_ALL
124: WHERE HEADER_ID = P_SALES_ORDER_HEADER_ID;
125: IF P_CUSTOMER_ID IS NULL THEN
126: SELECT
127: PARTY.PARTY_NAME,

Line 133: OE_ORDER_HEADERS_ALL OEH

129: INTO P_CUSTOMER_NAME,P_CUSTOMER_NUMBER
130: FROM
131: HZ_PARTIES PARTY,
132: HZ_CUST_ACCOUNTS CUST_ACCT,
133: OE_ORDER_HEADERS_ALL OEH
134: WHERE CUST_ACCT.CUST_ACCOUNT_ID = OEH.SOLD_TO_ORG_ID
135: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
136: AND OEH.HEADER_ID = P_SALES_ORDER_HEADER_ID;
137: END IF;