APPS.OE_DEFAULT_PVT dependencies on OE_ORDER_HEADERS

Line 38: from oe_order_headers_all

34: WHERE organization_id = X_Invoice_To_Org_Id;
35:
36: Cursor get_hdr_sold_inv(x_header_id number) is
37: SELECT sold_to_org_id, invoice_to_org_id
38: from oe_order_headers_all
39: where header_id = x_header_id;
40:
41: Cursor get_line_sold_inv(x_line_id number) is
42: SELECT sold_to_org_id, invoice_to_org_id

Line 390: from oe_order_headers_all

386: **/
387:
388: Cursor get_hdr_sold_inv(x_header_id number) is
389: SELECT sold_to_org_id, invoice_to_org_id
390: from oe_order_headers_all
391: where header_id = x_header_id;
392:
393: Cursor get_line_sold_inv(x_line_id number) is
394: SELECT sold_to_org_id, invoice_to_org_id

Line 980: FROM OE_ORDER_HEADERS_ALL

976: tax_exempt_reason_code
977: INTO l_tax_exempt_flag,
978: l_tax_exempt_number,
979: l_tax_exempt_reason_code
980: FROM OE_ORDER_HEADERS_ALL
981: WHERE header_id = ONT_LINE_Def_Hdlr.g_record.header_id;
982: IF l_tax_exempt_flag <> 'E' THEN
983: l_tax_exempt_number := NULL;
984: l_tax_exempt_reason_code := NULL;

Line 1309: p_entity_code => 'OE_ORDER_HEADERS',

1305: p_trx_date => trunc(ONT_LINE_DEF_HDLR.g_record.tax_date),
1306: p_trx_type_id => l_trx_type_id,
1307: p_tax_classification_code => x_tax_code,
1308: appl_short_name => 'ONT',
1309: p_entity_code => 'OE_ORDER_HEADERS',
1310: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
1311: p_application_id => 660,
1312: p_internal_organization_id => l_org_id);
1313:

Line 1396: FROM oe_order_headers

1392:
1393: IF ONT_LINE_Def_Hdlr.g_record.Agreement_id IS NOT NULL THEN
1394: SELECT transactional_curr_code
1395: INTO l_trans_curr_code
1396: FROM oe_order_headers
1397: WHERE header_id = ONT_LINE_Def_Hdlr.g_record.header_id;
1398:
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'AGREEMENT_ID: '||ONT_LINE_DEF_HDLR.G_RECORD.AGREEMENT_ID|| ' L_TRANS_CURR_CODE: '||L_TRANS_CURR_CODE ||' SOLD TO ORG: '||ONT_LINE_DEF_HDLR.G_RECORD.SOLD_TO_ORG_ID ) ;

Line 1528: FROM oe_order_headers

1524: END IF;
1525: IF l_rule_type = 'ACC_DUR' THEN
1526: SELECT accounting_rule_duration
1527: INTO l_accounting_rule_duration
1528: FROM oe_order_headers
1529: WHERE header_id = ONT_LINE_Def_Hdlr.g_record.header_id;
1530: IF l_debug_level > 0 THEN
1531: oe_debug_pub.add( 'EXITING OE_DEFAULT_PVT.GET_ACCOUNTING_RULE_DURATION - DURATION:'|| L_ACCOUNTING_RULE_DURATION ) ;
1532: END IF;

Line 1655: from oe_order_headers_all

1651:
1652: IF l_org_id IS NULL or l_org_id = FND_API.G_MISS_NUM THEN
1653: select org_id
1654: into l_org_id
1655: from oe_order_headers_all
1656: where header_id = l_header_id;
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('org_id:'||l_org_id);
1659: END IF;