APPS.JAI_AR_SUP_TRX_PKG dependencies on OE_ORDER_LINES_ALL

Line 642: b.interface_line_attribute6, -- oe_order_lines_all.line_id

638: b.link_to_cust_trx_line_id,
639: b.description,
640: b.interface_line_attribute3, -- delivery id is stored here.
641: b.interface_line_attribute7,
642: b.interface_line_attribute6, -- oe_order_lines_all.line_id
643: b.inventory_item_id,
644: c.bom_item_type,
645: d.mapping_type, -- added by sriram - bug # 3143813 - 19/09/2003
646: d.new_type_id,

Line 691: OE_ORDER_LINES_ALL B

687: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
688: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
689: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
690: FROM HZ_CUST_SITE_USES_ALL A,
691: OE_ORDER_LINES_ALL B
692: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
693: AND B.LINE_ID = PICKING_ID;
694: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
695: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS

Line 1075: FROM oe_order_lines_all

1071: SELECT PRICE_LIST_ID
1072: INTO P_PRICE_LIST
1073: FROM OE_ORDER_HEADERS_ALL
1074: WHERE header_id = (SELECT header_id
1075: FROM oe_order_lines_all
1076: WHERE line_id = FETCH_INV.INTERFACE_HEADER_ATTRIBUTE6
1077: AND org_id = FETCH_INV.org_id);
1078:
1079: EXCEPTION