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 53: FROM dpp_transaction_lines_all dtla

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

Line 72: FROM dpp_transaction_lines_all dtla

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

Line 92: FROM dpp_transaction_lines_all dtla

88:
89:
90: BEGIN
91: SELECT DISTINCT 'Y' INTO l_flag
92: FROM dpp_transaction_lines_all dtla
93: WHERE transaction_header_id = p_transaction_header_id
94: AND update_item_list_price IN ('Y','P') ;
95: SELECT meaning
96: INTO l_process_code

Line 111: FROM dpp_transaction_lines_all dtla

107: END;
108:
109: BEGIN
110: SELECT DISTINCT 'Y' INTO l_flag
111: FROM dpp_transaction_lines_all dtla
112: WHERE transaction_header_id = p_transaction_header_id
113: AND notify_inbound_pricelist IN ('Y','P') ;
114: SELECT meaning
115: INTO l_process_code

Line 130: FROM dpp_transaction_lines_all dtla

126: END;
127:
128: BEGIN
129: SELECT DISTINCT 'Y' INTO l_flag
130: FROM dpp_transaction_lines_all dtla
131: WHERE transaction_header_id = p_transaction_header_id
132: AND notify_outbound_pricelist IN ('Y','P') ;
133: SELECT meaning
134: INTO l_process_code

Line 149: FROM dpp_transaction_lines_all dtla

145: END;
146:
147: BEGIN
148: SELECT DISTINCT 'Y' INTO l_flag
149: FROM dpp_transaction_lines_all dtla
150: WHERE transaction_header_id = p_transaction_header_id
151: AND notify_promotions_pricelist IN ('Y','P') ;
152: SELECT meaning
153: INTO l_process_code

Line 167: FROM dpp_transaction_lines_all dtla

163: NULL;
164: END;
165: BEGIN
166: SELECT DISTINCT 'Y' INTO l_flag
167: FROM dpp_transaction_lines_all dtla
168: WHERE transaction_header_id = p_transaction_header_id
169: AND supp_dist_claim_status IN ('Y','P') ;
170: SELECT meaning
171: INTO l_process_code

Line 186: FROM dpp_transaction_lines_all dtla

182: END;
183:
184: BEGIN
185: SELECT DISTINCT 'Y' INTO l_flag
186: FROM dpp_transaction_lines_all dtla
187: WHERE transaction_header_id = p_transaction_header_id
188: AND supp_dist_claim_status IN ('Y','P') ;
189: SELECT meaning
190: INTO l_process_code

Line 214: FROM dpp_transaction_lines_all dtla

210:
211: ELSIF p_status_change = 'CLOSED' THEN
212: BEGIN
213: SELECT DISTINCT 'Y' INTO l_flag
214: FROM dpp_transaction_lines_all dtla
215: WHERE transaction_header_id = p_transaction_header_id
216: AND update_purchasing_docs IN ('N','P') ;
217: SELECT meaning
218: INTO l_process_code

Line 232: FROM dpp_transaction_lines_all dtla

228: NULL;
229: END;
230: BEGIN
231: SELECT DISTINCT 'Y' INTO l_flag
232: FROM dpp_transaction_lines_all dtla
233: WHERE transaction_header_id = p_transaction_header_id
234: AND notify_purchasing_docs IN ('N','P') ;
235: SELECT meaning
236: INTO l_process_code

Line 252: FROM dpp_transaction_lines_all dtla

248:
249:
250: BEGIN
251: SELECT DISTINCT 'Y' INTO l_flag
252: FROM dpp_transaction_lines_all dtla
253: WHERE transaction_header_id = p_transaction_header_id
254: AND update_inventory_costing IN ('N','P') ;
255: SELECT meaning
256: INTO l_process_code

Line 271: FROM dpp_transaction_lines_all dtla

267: END;
268:
269: BEGIN
270: SELECT DISTINCT 'Y' INTO l_flag
271: FROM dpp_transaction_lines_all dtla
272: WHERE transaction_header_id = p_transaction_header_id
273: AND update_item_list_price IN ('N','P') ;
274: SELECT meaning
275: INTO l_process_code

Line 290: FROM dpp_transaction_lines_all dtla

286: END;
287:
288: BEGIN
289: SELECT DISTINCT 'Y' INTO l_flag
290: FROM dpp_transaction_lines_all dtla
291: WHERE transaction_header_id = p_transaction_header_id
292: AND notify_inbound_pricelist IN ('N','P') ;
293: SELECT meaning
294: INTO l_process_code

Line 309: FROM dpp_transaction_lines_all dtla

305: END;
306:
307: BEGIN
308: SELECT DISTINCT 'Y' INTO l_flag
309: FROM dpp_transaction_lines_all dtla
310: WHERE transaction_header_id = p_transaction_header_id
311: AND notify_outbound_pricelist IN ('N','P') ;
312: SELECT meaning
313: INTO l_process_code

Line 328: FROM dpp_transaction_lines_all dtla

324: END;
325:
326: BEGIN
327: SELECT DISTINCT 'Y' INTO l_flag
328: FROM dpp_transaction_lines_all dtla
329: WHERE transaction_header_id = p_transaction_header_id
330: AND notify_promotions_pricelist IN ('N','P') ;
331: SELECT meaning
332: INTO l_process_code

Line 347: FROM dpp_transaction_lines_all dtla

343: END;
344:
345: BEGIN
346: SELECT DISTINCT 'Y' INTO l_flag
347: FROM dpp_transaction_lines_all dtla
348: WHERE transaction_header_id = p_transaction_header_id
349: AND supp_dist_claim_status IN ('N','P','D') ;
350: SELECT meaning
351: INTO l_process_code

Line 870: dpp_transaction_lines_all dtla

866: mtl_system_items_kfv msi,
867: mtl_parameters mp,
868: financials_system_params_all fspa,
869: oe_order_lines_all oola,
870: dpp_transaction_lines_all dtla
871: WHERE
872: dtla.transaction_header_id = TO_NUMBER(p_search_text1) and
873: p_search_criteria1 = 'TRANSACTION_HEADER_ID' AND
874: oola.inventory_item_id = dtla.inventory_item_id and

Line 1618: dpp_transaction_lines_all dtla

1614: FROM
1615: oe_order_lines_all oola,
1616: hz_cust_accounts hz,
1617: dpp_transaction_headers_all dtha,
1618: dpp_transaction_lines_all dtla
1619: WHERE
1620: oola.org_id = dtla.org_id and
1621: dtla.transaction_header_id = TO_NUMBER(p_search_text2) and
1622: dtla.transaction_header_id = dtha.transaction_header_id and