APPS.PKG_GMP_BUCKET_DATA dependencies on MTL_SYSTEM_ITEMS

Line 525: /* akaruppa changed the cursor to obtain the UOM from MTL_SYSTEM_ITEMS

521: CURSOR Get_ord_ind_cur IS
522: SELECT order_ind
523: FROM ps_schd_hdr
524: WHERE schedule_id = V_schedule;
525: /* akaruppa changed the cursor to obtain the UOM from MTL_SYSTEM_ITEMS
526: CURSOR Cur_item_um IS
527: SELECT item_um, item_um2
528: FROM ic_item_mst
529: WHERE item_id = V_item_id; */

Line 533: FROM mtl_system_items

529: WHERE item_id = V_item_id; */
530:
531: CURSOR Cur_item_um IS
532: SELECT DISTINCT primary_uom_code,secondary_uom_code
533: FROM mtl_system_items
534: WHERE inventory_item_id = V_item_id;
535:
536: CURSOR Cur_schedule IS
537: SELECT no_days, no_weeks, no_4weeks, no_13weeks

Line 652: ' mtl_system_items msi '||

648: ' FROM '||
649: ' gme_batch_header gbh, '||
650: ' gme_material_details gmd, '||
651: ' mtl_parameters mp, '||
652: ' mtl_system_items msi '||
653: ' WHERE '||
654: ' Gbh.batch_id = gmd.batch_id '||
655: ' AND msi.inventory_item_id = gmd.inventory_item_id '||
656: ' AND msi.organization_id = gmd.organization_id '||

Line 685: ' mtl_system_items items,'||

681: ' ) trans_qty, '||
682: ' org.organization_code '|| -- akaruppa previously iwm.whse_code
683: ' FROM '||
684: ' mtl_demand_omoe mtl,'||
685: ' mtl_system_items items,'||
686: ' oe_order_headers_all hdr, '||
687: ' oe_order_lines_all dtl, '||
688: ' mtl_parameters org '||
689: ' WHERE '||

Line 746: ' mtl_system_items msi, '||

742: ' FROM '||
743: ' ps_schd_for psf, '||
744: ' mrp_forecast_designators mff, '||
745: ' mrp_forecast_dates dtl, '||
746: ' mtl_system_items msi, '||
747: ' mtl_parameters mp '||
748: ' WHERE dtl.inventory_item_id = :p11 '||
749: ' AND psf.schedule_id = :p12 '||
750: ' AND INSTR(:p13, TO_CHAR(psf.organization_id)) <> 0 '||

Line 779: ' MTL_SYSTEM_ITEMS mitem '||

775: ' ) trans_qty, '||
776: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
777: ' FROM MTL_PARAMETERS mtl, '||
778: ' PO_PO_SUPPLY_VIEW po, '||
779: ' MTL_SYSTEM_ITEMS mitem '||
780: ' WHERE po.item_id = :p16 '|| -- akaruppa previously ic.item_id
781: ' AND po.item_id = mitem.inventory_item_id '||
782: ' AND po.to_organization_id = mitem.organization_id '||
783: ' AND mtl.organization_id = po.to_organization_id '||

Line 809: ' MTL_SYSTEM_ITEMS mitem '||

805: ' ) trans_qty, '||
806: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
807: ' FROM MTL_PARAMETERS mtl,'||
808: ' PO_REQ_SUPPLY_VIEW po,'||
809: ' MTL_SYSTEM_ITEMS mitem '||
810: ' WHERE po.item_id = :p20'|| -- akaruppa previously ic.item_id
811: ' AND po.item_id = mitem.inventory_item_id '||
812: ' AND po.to_organization_id = mitem.organization_id '||
813: ' AND mtl.organization_id = po.to_organization_id '||

Line 840: ' MTL_SYSTEM_ITEMS mitem '||

836: ' ) trans_qty, '||
837: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
838: ' FROM MTL_PARAMETERS mtl,'||
839: ' PO_RCV_SUPPLY_VIEW po,'||
840: ' MTL_SYSTEM_ITEMS mitem '||
841: ' WHERE po.item_id = :p24'|| -- akaruppa previously ic.item_id
842: ' AND po.item_id = mitem.inventory_item_id '||
843: ' AND po.to_organization_id = mitem.organization_id '||
844: ' AND mtl.organization_id = po.to_organization_id '||

Line 870: ' MTL_SYSTEM_ITEMS mitem '||

866: ' ) trans_qty, '||
867: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
868: ' FROM MTL_PARAMETERS mtl,'||
869: ' PO_SHIP_RCV_SUPPLY_VIEW po, '||
870: ' MTL_SYSTEM_ITEMS mitem '||
871: ' WHERE po.item_id = :p28'|| -- akaruppa previously ic.item_id
872: ' AND po.item_id = mitem.inventory_item_id '||
873: ' AND po.to_organization_id = mitem.organization_id '||
874: ' AND mtl.organization_id = po.to_organization_id '||

Line 900: ' FROM MTL_SYSTEM_ITEMS mitem,'||

896: ' NULL '||
897: ' ) '||
898: ' ) trans_qty, '||
899: ' mtl.organization_code '|| -- akaruppa previously iwm.whse_code
900: ' FROM MTL_SYSTEM_ITEMS mitem,'||
901: ' PO_SHIP_SUPPLY_VIEW po,'||
902: ' MTL_PARAMETERS mtl '||
903: ' WHERE po.item_id = :p32'|| -- akaruppa previously ic.item_id
904: ' AND po.item_id = mitem.inventory_item_id '||