APPS.JL_ZZ_RECEIV_INTERFACE dependencies on MTL_SYSTEM_ITEMS

Line 99: mtl_system_items msi

95: msi.global_attribute4 item_fiscal_type,
96: msi.global_attribute5 fed_trib_situation,
97: msi.global_attribute6 sta_trib_situation
98: FROM oe_order_lines ol,
99: mtl_system_items msi
100: WHERE line_id = l_line_id
101: AND msi.inventory_item_id(+) = l_inventory_item_id
102: AND msi.organization_id = l_so_organization_id;
103:

Line 433: FROM oe_order_lines ol, mtl_system_items msi

429: l_item_origin,
430: l_item_fiscal_type,
431: l_fed_trib_situation,
432: l_sta_trib_situation
433: FROM oe_order_lines ol, mtl_system_items msi
434: WHERE ol.line_id = l_order_line_id
435: AND msi.inventory_item_id(+) =
436: p_interface_line_rec.inventory_item_id
437: AND msi.organization_id = l_so_organization_id;

Line 527: mtl_system_items msi

523: msi.global_attribute4 item_fiscal_type,
524: msi.global_attribute5 fed_trib_situation,
525: msi.global_attribute6 sta_trib_situation
526: FROM oe_order_lines ol,
527: mtl_system_items msi
528: WHERE line_id = l_line_id
529: AND msi.inventory_item_id(+) = l_inventory_item_id
530: AND msi.organization_id = l_so_organization_id;
531:

Line 865: FROM oe_order_lines ol, mtl_system_items msi

861: l_item_origin,
862: l_item_fiscal_type,
863: l_fed_trib_situation,
864: l_sta_trib_situation
865: FROM oe_order_lines ol, mtl_system_items msi
866: WHERE ol.line_id = l_order_line_id
867: AND msi.inventory_item_id(+) =
868: x_interface_line_rec.inventory_item_id
869: AND msi.organization_id = l_so_organization_id;

Line 997: FROM mtl_system_items mtl

993:
994: BEGIN
995: SELECT substr(mtl.global_attribute2,1,30)
996: INTO l_tran_nat
997: FROM mtl_system_items mtl
998: WHERE mtl.organization_id = l_inventory_org_id
999: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1000: EXCEPTION
1001: WHEN OTHERS THEN

Line 1013: FROM mtl_system_items mtl

1009:
1010: BEGIN
1011: SELECT substr(mtl.global_attribute2,1,30)
1012: INTO l_tran_nat
1013: FROM mtl_system_items mtl
1014: WHERE mtl.organization_id = l_so_organization_id
1015: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1016: EXCEPTION
1017: WHEN OTHERS THEN

Line 1223: FROM mtl_system_items mtl

1219: l_tran_nat,
1220: l_item_orig,
1221: l_fed_trib,
1222: l_sta_trib
1223: FROM mtl_system_items mtl
1224: WHERE mtl.organization_id = l_inventory_org_id
1225: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1226: EXCEPTION
1227: WHEN OTHERS THEN

Line 1238: FROM mtl_system_items mtl

1234:
1235: BEGIN
1236: SELECT substr(mtl.global_attribute2,1,30)
1237: INTO l_tran_nat
1238: FROM mtl_system_items mtl
1239: WHERE mtl.organization_id = l_inventory_org_id
1240: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1241: EXCEPTION
1242: WHEN OTHERS THEN

Line 1254: FROM mtl_system_items mtl

1250:
1251: BEGIN
1252: SELECT substr(mtl.global_attribute2,1,30)
1253: INTO l_tran_nat
1254: FROM mtl_system_items mtl
1255: WHERE mtl.organization_id = l_so_organization_id
1256: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1257: EXCEPTION
1258: WHEN OTHERS THEN