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 1687: insert into msc_form_query

1683: arg_request_id, arg_user_id);
1684:
1685: END IF;
1686: */
1687: insert into msc_form_query
1688: (query_id ,
1689: last_update_date,
1690: last_updated_by,
1691: creation_date,

Line 1717: 'msc_form_query',

1713: 'NUMBER',
1714: to_char(insert_count),
1715: 'N',
1716: 'TABLE',
1717: 'msc_form_query',
1718: 'N');
1719:
1720: mrp_print_pk.stop_watch(arg_request_id,
1721: var_watch_id);