DBA Data[Home] [Help]

APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 969: FROM oe_order_headers_all /*Modified to base table for bug 9701486 */

965:
966: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
967: SELECT version_number
968: INTO l_v_number
969: FROM oe_order_headers_all /*Modified to base table for bug 9701486 */
970: WHERE header_id = p_header_id;
971:
972: IF NOT OE_GLOBALS.EQUAL(l_v_number,p_version_number) THEN
973: RETURN l_action_request_tbl;

Line 1136: from oe_order_headers_all

1132: From Oe_invoice_to_orgs_v
1133: Where organization_id = oe_order_cache.g_header_rec.invoice_to_org_id;
1134: Select invoice_to_org_id
1135: into l_invoice_to_org_id
1136: from oe_order_headers_all
1137: where header_id = p_header_id;
1138:
1139: --populate the header payment table with the trxn_extension_id
1140: --before process order api is called for the new order.

Line 4032: from oe_order_headers_all where header_id = l_header_id;

4028: l_cpy_category := Get_Order_Category(p_copy_rec.hdr_type);
4029: IF nvl(l_cpy_category,'NULL') <> 'RETURN' THEN --R12 CC Encryption
4030: --bug 5113795
4031: select payment_type_code into l_payment_type_code
4032: from oe_order_headers_all where header_id = l_header_id;
4033: IF l_debug_level > 0 THEN
4034: oe_debug_pub.add('Payment type code in copy order..ksurendr'||l_payment_type_code);
4035: oe_debug_pub.add('Header_id ...'||l_header_id);
4036: oe_debug_pub.add('Copy Header Payments flag...'||l_copy_header_payments);