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 957: FROM oe_order_headers_all

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

Line 1279: oe_order_headers_all oeh,

1275: INTO l_reservation_id
1276: FROM
1277: mtl_reservations mr,
1278: oe_order_lines_all oel,
1279: oe_order_headers_all oeh,
1280: oe_transaction_types_all ota,
1281: oe_transaction_types_tl otl,
1282: mtl_sales_orders mso
1283: WHERE

Line 1722: oe_order_headers_all oeh

1718: substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME
1719: into lcustomer_name
1720: FROM HZ_PARTIES PARTY,
1721: HZ_CUST_ACCOUNTS CUST_ACCT,
1722: oe_order_headers_all oeh
1723: WHERE CUST_ACCT.CUST_ACCOUNT_ID = oeh.sold_to_org_id
1724: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1725: AND oeh.header_id = l_header_id;
1726: