DBA Data[Home] [Help]

APPS.OE_DEFAULT_PVT dependencies on OE_ORDER_HEADERS_ALL

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 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;