DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 952: FROM mtl_system_items_kfv msik

948: ,msik.attribute13
949: ,msik.attribute14
950: ,msik.attribute15
951: ,poh.hazard_class
952: FROM mtl_system_items_kfv msik
953: ,po_hazard_classes poh
954: WHERE msik.organization_id = p_organization_id
955: AND msik.inventory_item_id = p_inventory_item_id
956: AND msik.hazard_class_id = poh.hazard_class_id(+);

Line 1114: , mtl_system_items_kfv msik

1110: , wlpn.attribute14
1111: , wlpn.attribute15
1112: , msik.concatenated_segments lpn_container_item
1113: FROM wms_license_plate_numbers wlpn
1114: , mtl_system_items_kfv msik
1115: , mtl_item_locations_kfv milk
1116: WHERE wlpn.lpn_id = p_lpn_id
1117: AND msik.organization_id(+) = wlpn.organization_id
1118: AND msik.inventory_item_id(+) = wlpn.inventory_item_id

Line 1325: , mtl_system_items_kfv msik_oi

1321: 'INT', msik_oi.concatenated_segments,
1322: msik_oi.concatenated_segments)) ordered_item
1323: FROM oe_order_lines_all oeol
1324: , mtl_customer_items mci_oi
1325: , mtl_system_items_kfv msik_oi
1326: WHERE oeol.line_id = p_line_id
1327: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)
1328: AND oeol.ordered_item_id = msik_oi.inventory_item_id (+)
1329: AND oeol.org_id = msik_oi.organization_id (+);