DBA Data[Home] [Help]

APPS.MSC_X_UDE_PEGGING dependencies on MSC_SUP_DEM_ENTRIES_UI_V

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