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 OE_ORDER_LINES

Line 102: FROM oe_order_lines ol,

98: nvl(ol.global_attribute9,msi.global_attribute3) item_origin, --bug 11795200
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;

Line 163: FROM oe_order_lines

159: SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
160: REFERENCE_LINE_ID
161: INTO l_invoice_line_id,
162: l_order_line_id
163: FROM oe_order_lines
164: WHERE line_id = l_line_id;
165: EXCEPTION
166: WHEN OTHERS THEN
167: l_invoice_line_id := NULL;

Line 334: from oe_order_lines

330: select global_attribute5,
331: global_attribute6
332: into l_fsc_cls_code,
333: l_trx_cls_code
334: from oe_order_lines
335: where line_id = l_line_id;
336: EXCEPTION
337: WHEN OTHERS THEN
338: l_fsc_cls_code := NULL;

Line 384: from oe_order_lines

380: select global_attribute5,
381: global_attribute6
382: into l_fsc_cls_code,
383: l_trx_cls_code
384: from oe_order_lines
385: where line_id = l_order_line_id;
386: EXCEPTION
387: WHEN OTHERS THEN
388: l_fsc_cls_code := NULL;

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 543: FROM oe_order_lines ol,

539: msi.global_attribute3 item_origin,
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;

Line 607: FROM oe_order_lines

603: SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
604: REFERENCE_LINE_ID
605: INTO l_invoice_line_id,
606: l_order_line_id
607: FROM oe_order_lines
608: WHERE line_id = l_line_id;
609: EXCEPTION
610: WHEN OTHERS THEN
611: l_invoice_line_id := NULL;

Line 778: from oe_order_lines

774: select global_attribute5,
775: global_attribute6
776: into l_fsc_cls_code,
777: l_trx_cls_code
778: from oe_order_lines
779: where line_id = l_line_id;
780: EXCEPTION
781: WHEN OTHERS THEN
782: l_fsc_cls_code := NULL;

Line 828: from oe_order_lines

824: select global_attribute5,
825: global_attribute6
826: into l_fsc_cls_code,
827: l_trx_cls_code
828: from oe_order_lines
829: where line_id = l_order_line_id;
830: EXCEPTION
831: WHEN OTHERS THEN
832: l_fsc_cls_code := NULL;

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;