APPS.CTO_CHANGE_ORDER_PK dependencies on OE_ORDER_HEADERS_ALL

Line 398: lorder_no oe_order_headers_all.order_number%type;

394: lcancel_line boolean := FALSE;
395: lconfig_line_id number;
396: i binary_integer;
397: lconfig_id oe_order_lines.configuration_id%type;
398: lorder_no oe_order_headers_all.order_number%type;
399: lheader_id oe_order_headers_all.header_id%type;
400: lplanner_code fnd_user.user_name%type; -- Modified by Renga on 11/24/04
401: --for bug 4026568
402: lOrg_id mtl_system_items.organization_id%type;

Line 399: lheader_id oe_order_headers_all.header_id%type;

395: lconfig_line_id number;
396: i binary_integer;
397: lconfig_id oe_order_lines.configuration_id%type;
398: lorder_no oe_order_headers_all.order_number%type;
399: lheader_id oe_order_headers_all.header_id%type;
400: lplanner_code fnd_user.user_name%type; -- Modified by Renga on 11/24/04
401: --for bug 4026568
402: lOrg_id mtl_system_items.organization_id%type;
403: lStmtNumber number;

Line 955: FROM oe_order_headers_all

951: -- Get the Order Number
952:
953: SELECT order_number
954: INTO lorder_no
955: FROM oe_order_headers_all
956: WHERE header_id = lheader_id;
957:
958:
959: IF PG_DEBUG <> 0 THEN

Line 1260: oe_order_headers_all oeh,

1256: INTO l_reservation_id
1257: FROM
1258: mtl_reservations mr,
1259: oe_order_lines_all oel,
1260: oe_order_headers_all oeh,
1261: oe_transaction_types_all ota,
1262: oe_transaction_types_tl otl,
1263: mtl_sales_orders mso
1264: WHERE

Line 1547: oe_order_headers_all oeh

1543: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME
1544: into lcustomer_name
1545: FROM HZ_PARTIES PARTY,
1546: HZ_CUST_ACCOUNTS CUST_ACCT,
1547: oe_order_headers_all oeh
1548: WHERE CUST_ACCT.CUST_ACCOUNT_ID = oeh.sold_to_org_id
1549: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1550: AND oeh.header_id = l_header_id;
1551: