APPS.DPP_UTILITY_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 34: FROM dpp_transaction_lines_all dtla

30:
31: IF p_status_change = 'CANCELLED' THEN
32: BEGIN
33: SELECT DISTINCT 'Y' INTO l_flag
34: FROM dpp_transaction_lines_all dtla
35: WHERE transaction_header_id = p_transaction_header_id
36: AND update_purchasing_docs IN ('Y','P') ;
37: SELECT meaning
38: INTO l_process_code

Line 52: FROM dpp_transaction_lines_all dtla

48:
49:
50: BEGIN
51: SELECT DISTINCT 'Y' INTO l_flag
52: FROM dpp_transaction_lines_all dtla
53: WHERE transaction_header_id = p_transaction_header_id
54: AND update_inventory_costing IN ('Y','P') ;
55: SELECT meaning
56: INTO l_process_code

Line 70: FROM dpp_transaction_lines_all dtla

66:
67:
68: BEGIN
69: SELECT DISTINCT 'Y' INTO l_flag
70: FROM dpp_transaction_lines_all dtla
71: WHERE transaction_header_id = p_transaction_header_id
72: AND update_item_list_price IN ('Y','P') ;
73: SELECT meaning
74: INTO l_process_code

Line 87: FROM dpp_transaction_lines_all dtla

83: END;
84:
85: BEGIN
86: SELECT DISTINCT 'Y' INTO l_flag
87: FROM dpp_transaction_lines_all dtla
88: WHERE transaction_header_id = p_transaction_header_id
89: AND supp_dist_claim_status IN ('Y','P') ;
90: SELECT meaning
91: INTO l_process_code

Line 129: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

125: ELSIF p_status_change = 'CLOSED' THEN
126:
127: BEGIN
128: SELECT DISTINCT 'Y' INTO l_flag
129: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
130: WHERE dep.transaction_header_id = dtla.transaction_header_id
131: AND dtla.transaction_header_id = p_transaction_header_id
132: AND dep.process_code = 'UPDTPO'
133: AND update_purchasing_docs IN ('N','P');

Line 152: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

148:
149:
150: BEGIN
151: SELECT DISTINCT 'Y' INTO l_flag
152: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
153: WHERE dep.transaction_header_id = dtla.transaction_header_id
154: AND dtla.transaction_header_id = p_transaction_header_id
155: AND dep.process_code = 'NTFYPO'
156: AND notify_purchasing_docs IN ('N','P') ;

Line 175: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

171:
172:
173: BEGIN
174: SELECT DISTINCT 'Y' INTO l_flag
175: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
176: WHERE dep.transaction_header_id = dtla.transaction_header_id
177: AND dtla.transaction_header_id = p_transaction_header_id
178: AND dep.process_code = 'INVC'
179: AND update_inventory_costing IN ('N','P') ;

Line 197: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

193: END;
194:
195: BEGIN
196: SELECT DISTINCT 'Y' INTO l_flag
197: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
198: WHERE dep.transaction_header_id = dtla.transaction_header_id
199: AND dtla.transaction_header_id = p_transaction_header_id
200: AND dep.process_code = 'UPDTLP'
201: AND update_item_list_price IN ('N','P') ;

Line 219: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

215: END;
216:
217: BEGIN
218: SELECT DISTINCT 'Y' INTO l_flag
219: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
220: WHERE dep.transaction_header_id = dtla.transaction_header_id
221: AND dtla.transaction_header_id = p_transaction_header_id
222: AND dep.process_code = 'INPL'
223: AND notify_inbound_pricelist IN ('N','P') ;

Line 241: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

237: END;
238:
239: BEGIN
240: SELECT DISTINCT 'Y' INTO l_flag
241: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
242: WHERE dep.transaction_header_id = dtla.transaction_header_id
243: AND dtla.transaction_header_id = p_transaction_header_id
244: AND dep.process_code = 'OUTPL'
245: AND notify_outbound_pricelist IN ('N','P') ;

Line 263: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

259: END;
260:
261: BEGIN
262: SELECT DISTINCT 'Y' INTO l_flag
263: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
264: WHERE dep.transaction_header_id = dtla.transaction_header_id
265: AND dtla.transaction_header_id = p_transaction_header_id
266: AND dep.process_code = 'PROMO'
267: AND notify_promotions_pricelist IN ('N','P') ;

Line 285: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla

281: END;
282:
283: BEGIN
284: SELECT DISTINCT 'Y' INTO l_flag
285: FROM dpp_execution_processes dep, dpp_transaction_lines_all dtla
286: WHERE dep.transaction_header_id = dtla.transaction_header_id
287: AND dtla.transaction_header_id = p_transaction_header_id
288: AND dep.process_code = 'DSTRINVCL'
289: AND supp_dist_claim_status IN ('N','P','D') ;

Line 832: dpp_transaction_lines_all dtla

828: mtl_system_items_kfv msi,
829: mtl_parameters mp,
830: financials_system_params_all fspa,
831: oe_order_lines_all oola,
832: dpp_transaction_lines_all dtla
833: WHERE
834: dtla.transaction_header_id = TO_NUMBER(p_search_text1) and
835: p_search_criteria1 = 'TRANSACTION_HEADER_ID' AND
836: oola.inventory_item_id = dtla.inventory_item_id and

Line 923: dpp_transaction_lines_all dtla

919: FROM
920: mtl_system_items_kfv msi,
921: mtl_parameters mp,
922: financials_system_params_all fspa,
923: dpp_transaction_lines_all dtla
924: WHERE
925: dtla.transaction_header_id = TO_NUMBER(p_search_text1) AND
926: p_search_criteria1 = 'TRANSACTION_HEADER_ID' AND
927: (dtla.prior_price - NVL(dtla.supplier_new_price,0)) > 0 AND

Line 1651: dpp_transaction_lines_all dtla

1647: oe_order_lines_all oola,
1648: hz_cust_accounts hz,
1649: hz_parties hp,
1650: dpp_transaction_headers_all dtha,
1651: dpp_transaction_lines_all dtla
1652: WHERE
1653: oola.org_id = dtla.org_id and
1654: dtla.transaction_header_id = TO_NUMBER(p_search_text2) and
1655: dtla.transaction_header_id = dtha.transaction_header_id and