APPS.MSC_X_UDE_PEGGING dependencies on MSC_SUP_DEM_ENTRIES

Line 14: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child

10: BEGIN
11: SELECT min(child.receipt_date), max(child.receipt_date),
12: sum(decode(sys_context('MSC','COMPANY_ID'), child.publisher_id, child.primary_quantity, decode(child.publisher_id, child.customer_id, child.supplier_id, child.customer_id), child.tp_quantity, child.quantity))
13: INTO so_min_receipt_date, so_max_receipt_date, so_sum_quantity
14: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child
15: WHERE parent.plan_id = -1
16: AND parent.publisher_order_type = PURCHASE_ORDER
17: AND exists
18: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between

Line 110: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child

106: SELECT parent.receipt_date,
107: decode(sys_context('MSC','COMPANY_ID'), parent.publisher_id, parent.primary_quantity, decode(parent.publisher_id, parent.customer_id, parent.supplier_id, parent.customer_id), parent.tp_quantity, parent.quantity),
108: parent.transaction_id
109: INTO l_need_by_date, l_quantity, l_po_transaction
110: FROM msc_sup_dem_entries parent, msc_sup_dem_entries child
111: WHERE parent.publisher_order_type = PURCHASE_ORDER
112: AND parent.plan_id = -1
113: AND exists
114: (select 1 from MSC_X_SECURITY_RULES rule where sysdate between

Line 198: FROM msc_sup_dem_entries msde

194: BEGIN
195:
196: SELECT msde.publisher_order_type, msde.receipt_date
197: INTO l_order_type, l_receipt_date
198: FROM msc_sup_dem_entries msde
199: WHERE msde.transaction_id = p_transaction_id
200: AND msde.publisher_order_type IN (PURCHASE_ORDER, SALES_ORDER);
201:
202: IF l_order_type = SALES_ORDER THEN

Line 241: FROM msc_sup_dem_entries_ui_v

237: BEGIN
238:
239: SELECT publisher_order_type, receipt_date
240: INTO l_order_type, l_receipt_date
241: FROM msc_sup_dem_entries_ui_v
242: WHERE transaction_id = p_transaction_id
243: AND publisher_order_type in (PURCHASE_ORDER, SALES_ORDER);
244:
245: IF l_order_type = SALES_ORDER THEN

Line 282: FROM msc_sup_dem_entries_ui_v

278:
279: SELECT publisher_order_type, receipt_date,
280: decode(sys_context('MSC','COMPANY_ID'), publisher_id, primary_quantity, decode(publisher_id, customer_id, supplier_id, customer_id), tp_quantity, quantity)
281: INTO l_order_type, l_receipt_date, l_quantity
282: FROM msc_sup_dem_entries_ui_v
283: WHERE transaction_id = p_transaction_id
284: AND publisher_order_type in (PURCHASE_ORDER, SALES_ORDER);
285:
286: IF l_order_type IN (SALES_ORDER, PURCHASE_ORDER) THEN