APPS.BOM_DIAGUNITTEST_IBRDATA dependencies on MTL_SYSTEM_ITEMS_B

Line 36: FROM mtl_system_items_b

32: l_oracle_schema VARCHAR2 (30);
33:
34: CURSOR c_item_valid (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS
35: SELECT count(*)
36: FROM mtl_system_items_b
37: WHERE inventory_item_id = cp_n_item_id
38: AND organization_id = nvl(cp_n_org_id,organization_id);
39:
40:

Line 204: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||

200: ' (PLU_RDEC.DISPLAYED_FIELD || '' ('' || MSIB.RECEIPT_DAYS_EXCEPTION_CODE || '')'')) "RECEIPT DAYS EXCEPTION CODE" '||
201: ' ,MSIB.RECEIVING_ROUTING_ID "RECEIVING ROUTING ID" '||
202: ' ,MSIB.INVOICE_CLOSE_TOLERANCE "INVOICE CLOSE TOLERANCE" '||
203: ' ,MSIB.RECEIVE_CLOSE_TOLERANCE "RECEIVE CLOSE TOLERANCE" '||
204: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||
205: ' ,mtl_parameters mp '||
206: ' ,MFG_LOOKUPS MLU_RQCC '||
207: ' ,PO_LOOKUP_CODES PLU_QREC '||
208: ' ,PO_LOOKUP_CODES PLU_ESLC '||

Line 306: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||

302: ' (MLU_WST.MEANING || '' ('' || MSIB.WIP_SUPPLY_TYPE || '')'')) "WIP SUPPLY TYPE" '||
303: ' ,MSIB.WIP_SUPPLY_SUBINVENTORY "WIP SUPPLY SUBINVENTORY" '||
304: ' ,MSIB.OVERCOMPLETION_TOLERANCE_TYPE "OVERCOMPLETION TOLERANCE TYPE" '||
305: ' ,MSIB.OVERCOMPLETION_TOLERANCE_VALUE "OVERCOMPLETION TOLERANCE VALUE" '||
306: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||
307: ' ,mtl_parameters mp, mtl_item_flexfields mif2 '||
308: ' ,MFG_LOOKUPS MLU_LOTCC '||
309: ' ,MFG_LOOKUPS MLU_SLC '||
310: ' ,MFG_LOOKUPS MLU_SNCC '||

Line 469: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||

465: ' ,MSIB.GLOBAL_ATTRIBUTE2 "GLOBAL ATTRIBUTE2" '||
466: ' ,MSIB.GLOBAL_ATTRIBUTE3 "GLOBAL ATTRIBUTE3" '||
467: ' ,MSIB.GLOBAL_ATTRIBUTE4 "GLOBAL ATTRIBUTE4" '||
468: ' ,MSIB.GLOBAL_ATTRIBUTE5 "GLOBAL ATTRIBUTE5" '||
469: ' FROM mtl_system_items_b msib, mtl_item_flexfields mif '||
470: ' ,mtl_parameters mp '||
471: ' ,MFG_LOOKUPS MLU_AULC '||
472: ' ,MFG_LOOKUPS MLU_IPC '||
473: ' ,MFG_LOOKUPS MLU_PMBC '||

Line 625: ' FROM mtl_system_items_b msib , mtl_item_flexfields mif '||

621: ' ,MSIB.CONVERGENCE "CONVERGENCE" '||
622: ' ,MSIB.DIVERGENCE "DIVERGENCE" '||
623: ' ,MSIB.CONFIG_ORGS "CONFIG ORGS" '||
624: ' ,MSIB.CONFIG_MATCH "CONFIG MATCH" '||
625: ' FROM mtl_system_items_b msib , mtl_item_flexfields mif '||
626: ' ,mtl_parameters mp '||
627: ' where 1=1 '||
628: ' and msib.inventory_item_id= mif.inventory_item_id '||
629: ' and msib.organization_id = mif.organization_id '||

Line 702: ' FROM mtl_system_items_b msib , mtl_item_flexfields mif '||

698: ' ,MSIB.PREPOSITION_POINT "PREPOSITION POINT" '||
699: ' ,MSIB.REPAIR_PROGRAM "REPAIR PROGRAM" '||
700: ' ,MSIB.SUBCONTRACTING_COMPONENT "SUBCONTRACTING COMPONENT" '||
701: ' ,MSIB.OUTSOURCED_ASSEMBLY "OUTSOURCED ASSEMBLY" '||
702: ' FROM mtl_system_items_b msib , mtl_item_flexfields mif '||
703: ' ,mtl_parameters mp '||
704: ' where 1=1 '||
705: ' and msib.inventory_item_id= mif.inventory_item_id '||
706: ' and msib.organization_id = mif.organization_id '||

Line 729: /* End of sql to fetch rows in mtl_system_items_b */

725:
726: statusStr := 'SUCCESS';
727: isFatal := 'FALSE';
728:
729: /* End of sql to fetch rows in mtl_system_items_b */
730:
731: /* SQL to fetch rows in mtl_system_items_tl table */
732: sqltxt := 'SELECT '||
733: ' MIF1.PADDED_ITEM_NUMBER "ITEM NUMBER" '||