APPS.MRP_MANAGER_PK dependencies on MSC_FORM_QUERY

Line 658: FROM Msc_FORM_QUERY query

654: NVL(dem.demand_class_code, 'A')
655: AND updates.process_status <> 3))
656: AND (NOT EXISTS
657: (SELECT NULL
658: FROM Msc_FORM_QUERY query
659: WHERE query.query_id = dem.line_id))
660: AND rownum <= UPDATE_BATCH_SIZE
661: -- BUG 2848262, Either record
662: AND (dem.visible_demand_flag = 'Y' -- can be inserted

Line 740: FROM Msc_FORM_QUERY query

736: AND dem.SHIP_TO_ORG_ID IS NOT NULL
737: AND dem.INVOICE_TO_ORG_ID IS NOT NULL
738: AND (NOT EXISTS
739: (SELECT NULL
740: FROM Msc_FORM_QUERY query
741: WHERE query.query_id = dem.line_id))
742: AND DECODE(dem.SOURCE_DOCUMENT_TYPE_ID, 10, 8,
743: DECODE(dem.LINE_CATEGORY_CODE, 'ORDER',2,12))
744: IN (MTL_SALES_ORDER, MTL_INT_SALES_ORDER)

Line 1692: insert into msc_form_query

1688: arg_request_id, arg_user_id);
1689:
1690: END IF;
1691: */
1692: insert into msc_form_query
1693: (query_id ,
1694: last_update_date,
1695: last_updated_by,
1696: creation_date,

Line 1722: 'msc_form_query',

1718: 'NUMBER',
1719: to_char(insert_count),
1720: 'N',
1721: 'TABLE',
1722: 'msc_form_query',
1723: 'N');
1724:
1725: mrp_print_pk.stop_watch(arg_request_id,
1726: var_watch_id);