APPS.JL_ZZ_RECEIV_INTERFACE dependencies on OE_ORDER_LINES

Line 98: FROM oe_order_lines ol,

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

Line 159: FROM oe_order_lines

155: SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
156: REFERENCE_LINE_ID
157: INTO l_invoice_line_id,
158: l_order_line_id
159: FROM oe_order_lines
160: WHERE line_id = l_line_id;
161: EXCEPTION
162: WHEN OTHERS THEN
163: l_invoice_line_id := NULL;

Line 320: from oe_order_lines

316: select global_attribute5,
317: global_attribute6
318: into l_fsc_cls_code,
319: l_trx_cls_code
320: from oe_order_lines
321: where line_id = l_line_id;
322: EXCEPTION
323: WHEN OTHERS THEN
324: l_fsc_cls_code := NULL;

Line 370: from oe_order_lines

366: select global_attribute5,
367: global_attribute6
368: into l_fsc_cls_code,
369: l_trx_cls_code
370: from oe_order_lines
371: where line_id = l_order_line_id;
372: EXCEPTION
373: WHEN OTHERS THEN
374: l_fsc_cls_code := NULL;

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

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

Line 590: FROM oe_order_lines

586: SELECT REFERENCE_CUSTOMER_TRX_LINE_ID,
587: REFERENCE_LINE_ID
588: INTO l_invoice_line_id,
589: l_order_line_id
590: FROM oe_order_lines
591: WHERE line_id = l_line_id;
592: EXCEPTION
593: WHEN OTHERS THEN
594: l_invoice_line_id := NULL;

Line 752: from oe_order_lines

748: select global_attribute5,
749: global_attribute6
750: into l_fsc_cls_code,
751: l_trx_cls_code
752: from oe_order_lines
753: where line_id = l_line_id;
754: EXCEPTION
755: WHEN OTHERS THEN
756: l_fsc_cls_code := NULL;

Line 802: from oe_order_lines

798: select global_attribute5,
799: global_attribute6
800: into l_fsc_cls_code,
801: l_trx_cls_code
802: from oe_order_lines
803: where line_id = l_order_line_id;
804: EXCEPTION
805: WHEN OTHERS THEN
806: l_fsc_cls_code := NULL;

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;