DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on MRP_WO_SUB_COMP

Line 1666: '.MRP_WO_SUB_COMP ';

1662:
1663: lv_mrp_schema := MSC_UTIL.G_MRP_SCHEMA;
1664:
1665: lv_trunc_stmt := ' TRUNCATE TABLE ' || lv_mrp_schema ||
1666: '.MRP_WO_SUB_COMP ';
1667: EXECUTE IMMEDIATE lv_trunc_stmt;
1668:
1669: lv_sql_stmt :=
1670: 'select WIP_ENTITY_ID, ORGANIZATION_ID ' ||

Line 1710: INSERT INTO MRP_WO_SUB_COMP

1706: END;
1707:
1708: IF( L_ALT_ITEM_TBL.Count > 0 ) THEN
1709: FORALL k IN 1..L_ALT_ITEM_TBL.count
1710: INSERT INTO MRP_WO_SUB_COMP
1711: (WIP_ENTITY_ID,
1712: ORGANIZATION_ID,
1713: PRIMARY_COMPONENT_ID,
1714: ALTERNATE_COMPONENT_ID,

Line 1744: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Populating MRP_WO_SUB_COMP');

1740:
1741:
1742: EXCEPTION WHEN OTHERS THEN
1743: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG(SQLERRM);
1744: MRP_CL_REFRESH_SNAPSHOT.LOG_DEBUG('There was an error in Populating MRP_WO_SUB_COMP');
1745: Return(0);
1746: END POPULATE_WO_SUB_COMP ;
1747:
1748: FUNCTION get_ship_set_name(p_SHIP_SET_ID in number)