APPS.CLN_WSH_SHIP_ORDER_OUT_PKG dependencies on WSH_TRANSACTIONS_HISTORY

Line 90: FROM WSH_TRANSACTIONS_HISTORY

86:
87: -- This query can never fail
88: SELECT ENTITY_NUMBER
89: INTO l_entity_number
90: FROM WSH_TRANSACTIONS_HISTORY
91: WHERE ENTITY_TYPE ='DLVY'
92: AND DOCUMENT_NUMBER = p_delivery_number
93: AND ROWNUM < 2;
94:

Line 97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history

93: AND ROWNUM < 2;
94:
95:
96: -- Set event parameters
97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);

Line 216: FROM WSH_TRANSACTIONS_HISTORY

212:
213: -- This query can never fail
214: SELECT ENTITY_NUMBER
215: INTO l_entity_number
216: FROM WSH_TRANSACTIONS_HISTORY
217: WHERE ENTITY_TYPE ='DLVY'
218: AND DOCUMENT_NUMBER = p_delivery_number
219: AND ROWNUM < 2;
220:

Line 312: WSH_TRANSACTIONS_HISTORY WTH,

308:
309: SELECT WDD.CUST_PO_NUMBER, WDD.CUSTOMER_ID, WND.CREATION_DATE
310: INTO x_customer_po_number, x_customer_id, x_delivery_creation_date
311: FROM WSH_NEW_DELIVERIES WND,
312: WSH_TRANSACTIONS_HISTORY WTH,
313: WSH_DELIVERY_DETAILS WDD,
314: WSH_DELIVERY_ASSIGNMENTS WDA
315: WHERE WTH.ENTITY_NUMBER = WND.NAME
316: AND WTH.ENTITY_TYPE ='DLVY'

Line 390: WSH_TRANSACTIONS_HISTORY WTH

386:
387: SELECT WND.ORGANIZATION_ID
388: INTO l_org_id
389: FROM WSH_NEW_DELIVERIES WND,
390: WSH_TRANSACTIONS_HISTORY WTH
391: WHERE WTH.ENTITY_NUMBER = WND.NAME
392: AND WTH.ENTITY_TYPE ='DLVY'
393: AND WTH.DOCUMENT_DIRECTION = 'O'
394: AND WTH.DOCUMENT_NUMBER = P_DOCUMENT_NUMBER;

Line 462: WSH_TRANSACTIONS_HISTORY WTH

458:
459: SELECT WND.INITIAL_PICKUP_LOCATION_ID
460: INTO l_loc_id
461: FROM WSH_NEW_DELIVERIES WND,
462: WSH_TRANSACTIONS_HISTORY WTH
463: WHERE WTH.ENTITY_NUMBER = WND.NAME
464: AND WTH.ENTITY_TYPE ='DLVY'
465: AND WTH.DOCUMENT_DIRECTION = 'O'
466: AND WTH.DOCUMENT_NUMBER = P_DOCUMENT_NUMBER;