DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on MTL_SYSTEM_ITEMS

Line 39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,

35: PROCEDURE get_data(
36: x_out_tbl IN OUT NOCOPY output_tbl_type,
37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,
38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,
42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE
43: ) IS

Line 40: p_organization_id mtl_system_items.organization_id%TYPE,

36: x_out_tbl IN OUT NOCOPY output_tbl_type,
37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,
38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,
42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE
43: ) IS
44:

Line 71: FROM MTL_SYSTEM_ITEMS_KFV item,

67: item.attribute9,
68: item.attribute_category,
69: item_poh. hazard_class,
70: item_mir.revision
71: FROM MTL_SYSTEM_ITEMS_KFV item,
72: PO_HAZARD_CLASSES item_poh,
73: MTL_ITEM_REVISIONS item_mir
74: WHERE item.organization_id = p_organization_id
75: AND item.inventory_item_id = p_inventory_item_id

Line 739: mtl_system_items_kfv lpn_msik1,

735: decode(lpn_wlc.serial_summary_entry, 1, 1, lpn_wlc.quantity)) quantity,
736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc
743: WHERE lpn.lpn_id = p_lpn_id

Line 740: mtl_system_items_kfv lpn_msik2,

736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc
743: WHERE lpn.lpn_id = p_lpn_id
744: AND lpn.parent_lpn_id = lpn_pLpn.lpn_id(+)

Line 1804: lot_control_code mtl_system_items.lot_control_code%TYPE,

1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,
1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE
1807: );
1808:

Line 1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,

1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,
1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE
1807: );
1808:
1809:

Line 1878: MTL_SYSTEM_ITEMS msi,

1874: msi.serial_number_control_code serial_number_control_code,
1875: mmtt.transaction_temp_id transaction_id
1876: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1877: MTL_TRANSACTION_LOTS_TEMP mtlt,
1878: MTL_SYSTEM_ITEMS msi,
1879: WIP_ENTITIES WE,
1880: WIP_FLOW_SCHEDULES wfs
1881: WHERE mmtt.transaction_temp_id = l_transaction_id
1882: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 1925: MTL_SYSTEM_ITEMS msi,

1921: msi.serial_number_control_code serial_number_control_code,
1922: mmtt.transaction_temp_id transaction_id
1923: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1924: MTL_TRANSACTION_LOTS_TEMP mtlt,
1925: MTL_SYSTEM_ITEMS msi,
1926: WIP_ENTITIES WE,
1927: WIP_FLOW_SCHEDULES wfs,
1928: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt_orig
1929: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 1978: MTL_SYSTEM_ITEMS msi,

1974: -- Bug 2904877, change back to using MTLI,
1975: -- this depends on WIP's fix on bug 2904857
1976: MTL_TRANSACTION_LOTS_INTERFACE mtli,
1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,
1978: MTL_SYSTEM_ITEMS msi,
1979: WIP_FLOW_SCHEDULES wfs
1980: WHERE mti.transaction_interface_id = l_transaction_id
1981: -- AND mti.transaction_interface_id = mtli.transaction_interface_id(+) -- Bug 2576424 : joabraha
1982: -- AND mti.transaction_interface_id = mtlt.transaction_temp_id(+) -- Bug 2576424 : joabraha

Line 2022: MTL_SYSTEM_ITEMS msi,

2018: mmtt.transaction_temp_id transaction_id
2019: FROM MTL_TXN_REQUEST_LINES mtrl,
2020: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2021: MTL_TRANSACTION_LOTS_TEMP mtlt,
2022: MTL_SYSTEM_ITEMS msi,
2023: WIP_ENTITIES WE
2024: WHERE mtrl.line_id = l_transaction_id
2025: AND mtrl.line_id = mmtt.move_order_line_id(+)
2026: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 2064: MTL_SYSTEM_ITEMS msi,

2060: mmtt.transaction_temp_id transaction_id
2061: FROM WIP_FLOW_SCHEDULES wfs,
2062: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2063: MTL_TRANSACTION_LOTS_TEMP mtlt,
2064: MTL_SYSTEM_ITEMS msi,
2065: WIP_ENTITIES WE
2066: WHERE mmtt.transaction_source_type_id = 5
2067: AND mmtt.transaction_action_id = 31
2068: AND mmtt.organization_id = wfs.organization_id

Line 2109: mtl_system_items msi

2105: FROM wip_flow_schedules wfs,
2106: mtl_material_transactions mmt,
2107: mtl_transaction_lot_numbers mtln,
2108: wip_entities we,
2109: mtl_system_items msi
2110: WHERE mmt.transaction_source_type_id = 5
2111: AND mmt.transaction_action_id = 31
2112: AND mmt.organization_id = wfs.organization_id
2113: AND mmt.inventory_item_id = wfs.primary_item_id

Line 2153: mtl_system_items msi

2149: msi.serial_number_control_code,
2150: NULL transaction_id
2151: FROM wip_flow_schedules wfs,
2152: wip_entities we,
2153: mtl_system_items msi
2154: WHERE wfs.organization_id = msi.organization_id
2155: AND wfs.primary_item_id = msi.inventory_item_id
2156: AND we.wip_entity_id = wfs.wip_entity_id
2157: AND we.entity_type = 4