eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_RECEIV_INTERFACE dependencies on MTL_SYSTEM_ITEMS

Line 103: mtl_system_items msi

99: msi.global_attribute4 item_fiscal_type,
100: nvl(ol.global_attribute10,msi.global_attribute5) fed_trib_situation, --bug 11795200
101: nvl(ol.global_attribute11,msi.global_attribute6) sta_trib_situation --bug 11795200
102: FROM oe_order_lines ol,
103: mtl_system_items msi
104: WHERE line_id = l_line_id
105: AND msi.inventory_item_id(+) = l_inventory_item_id
106: AND msi.organization_id = l_so_organization_id;
107:

Line 447: FROM oe_order_lines ol, mtl_system_items msi

443: l_item_origin,
444: l_item_fiscal_type,
445: l_fed_trib_situation,
446: l_sta_trib_situation
447: FROM oe_order_lines ol, mtl_system_items msi
448: WHERE ol.line_id = l_order_line_id
449: AND msi.inventory_item_id(+) =
450: p_interface_line_rec.inventory_item_id
451: AND msi.organization_id = l_so_organization_id;

Line 544: mtl_system_items msi

540: msi.global_attribute4 item_fiscal_type,
541: msi.global_attribute5 fed_trib_situation,
542: msi.global_attribute6 sta_trib_situation
543: FROM oe_order_lines ol,
544: mtl_system_items msi
545: WHERE line_id = l_line_id
546: AND msi.inventory_item_id(+) = l_inventory_item_id
547: AND msi.organization_id = l_so_organization_id;
548:

Line 891: FROM oe_order_lines ol, mtl_system_items msi

887: l_item_origin,
888: l_item_fiscal_type,
889: l_fed_trib_situation,
890: l_sta_trib_situation
891: FROM oe_order_lines ol, mtl_system_items msi
892: WHERE ol.line_id = l_order_line_id
893: AND msi.inventory_item_id(+) =
894: x_interface_line_rec.inventory_item_id
895: AND msi.organization_id = l_so_organization_id;

Line 1023: FROM mtl_system_items mtl

1019:
1020: BEGIN
1021: SELECT substr(mtl.global_attribute2,1,30)
1022: INTO l_tran_nat
1023: FROM mtl_system_items mtl
1024: WHERE mtl.organization_id = l_inventory_org_id
1025: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1026: EXCEPTION
1027: WHEN OTHERS THEN

Line 1039: FROM mtl_system_items mtl

1035:
1036: BEGIN
1037: SELECT substr(mtl.global_attribute2,1,30)
1038: INTO l_tran_nat
1039: FROM mtl_system_items mtl
1040: WHERE mtl.organization_id = l_so_organization_id
1041: AND mtl.inventory_item_id = p_line_rec.inventory_item_id;
1042: EXCEPTION
1043: WHEN OTHERS THEN

Line 1192: (c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE,

1188: l_jl VARCHAR2(2);
1189:
1190: -- bug#7827647
1191: CURSOR c_get_gdf_br
1192: (c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE,
1193: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
1194: )
1195: IS
1196: SELECT substr(mtl.global_attribute2,1,30),

Line 1193: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE

1189:
1190: -- bug#7827647
1191: CURSOR c_get_gdf_br
1192: (c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE,
1193: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
1194: )
1195: IS
1196: SELECT substr(mtl.global_attribute2,1,30),
1197: substr(mtl.global_attribute3,1,30),

Line 1200: FROM mtl_system_items mtl

1196: SELECT substr(mtl.global_attribute2,1,30),
1197: substr(mtl.global_attribute3,1,30),
1198: substr(mtl.global_attribute5,1,30),
1199: substr(mtl.global_attribute6,1,30)
1200: FROM mtl_system_items mtl
1201: WHERE mtl.organization_id = c_inventory_org_id
1202: AND mtl.inventory_item_id = c_inventory_item_id;
1203:
1204: -- bug#7827647

Line 1290: FROM mtl_system_items mtl

1286: l_tran_nat,
1287: l_item_orig,
1288: l_fed_trib,
1289: l_sta_trib
1290: FROM mtl_system_items mtl
1291: WHERE mtl.organization_id = l_inventory_org_id
1292: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1293: EXCEPTION
1294: WHEN OTHERS THEN

Line 1335: FROM mtl_system_items mtl

1331:
1332: BEGIN
1333: SELECT substr(mtl.global_attribute2,1,30)
1334: INTO l_tran_nat
1335: FROM mtl_system_items mtl
1336: WHERE mtl.organization_id = l_inventory_org_id
1337: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1338: EXCEPTION
1339: WHEN OTHERS THEN

Line 1351: FROM mtl_system_items mtl

1347:
1348: BEGIN
1349: SELECT substr(mtl.global_attribute2,1,30)
1350: INTO l_tran_nat
1351: FROM mtl_system_items mtl
1352: WHERE mtl.organization_id = l_so_organization_id
1353: AND mtl.inventory_item_id = x_line_rec.inventory_item_id;
1354: EXCEPTION
1355: WHEN OTHERS THEN