APPS.JAI_AR_SUP_TRX_PKG dependencies on OE_ORDER_LINES_ALL

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

568: b.link_to_cust_trx_line_id,
569: b.description,
570: b.interface_line_attribute3, -- delivery id is stored here.
571: b.interface_line_attribute7,
572: b.interface_line_attribute6, -- oe_order_lines_all.line_id
573: b.inventory_item_id,
574: c.bom_item_type,
575: d.mapping_type, -- added by sriram - bug # 3143813 - 19/09/2003
576: d.new_type_id,

Line 619: OE_ORDER_LINES_ALL B

615: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
616: CURSOR GET_ADDRESS_OE(PICKING_ID VARCHAR2 ) IS
617: SELECT DISTINCT A.CUST_ACCT_SITE_ID ADDRESS_ID
618: FROM HZ_CUST_SITE_USES_ALL A,
619: OE_ORDER_LINES_ALL B
620: WHERE A.SITE_USE_ID = B.SHIP_TO_ORG_ID
621: AND B.LINE_ID = PICKING_ID;
622: /* Removed ra_site_uses_all used hz_cust_site_uses_all for Bug# 4434287 */
623: CURSOR GET_ADDRESS_AR(p_ship_to_site_id number) IS

Line 974: FROM oe_order_lines_all

970: SELECT PRICE_LIST_ID
971: INTO P_PRICE_LIST
972: FROM OE_ORDER_HEADERS_ALL
973: WHERE header_id = (SELECT header_id
974: FROM oe_order_lines_all
975: WHERE line_id = FETCH_INV.INTERFACE_HEADER_ATTRIBUTE6
976: AND org_id = FETCH_INV.org_id);
977:
978: EXCEPTION