DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_PVT dependencies on OE_PRICE_ADJS_IFACE_ALL

Line 654: FROM oe_price_adjs_iface_all

650: , nvl( CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR)
651: , nvl( PRICING_PHASE_ID, FND_API.G_MISS_NUM)
652: , nvl( ADJUSTED_AMOUNT, FND_API.G_MISS_NUM)
653: -- Price Adjustment related changes bug# 1220921 (End)
654: FROM oe_price_adjs_iface_all
655: WHERE order_source_id = l_order_source_id
656: AND orig_sys_document_ref = l_orig_sys_document_ref
657: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
658: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)

Line 1470: FROM oe_price_adjs_iface_all

1466: , nvl( CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR)
1467: , nvl( PRICING_PHASE_ID, FND_API.G_MISS_NUM)
1468: , nvl( ADJUSTED_AMOUNT, FND_API.G_MISS_NUM)
1469: -- Price Adjustment related changes bug# 1220921 (End)
1470: FROM oe_price_adjs_iface_all
1471: WHERE order_source_id = l_order_source_id
1472: AND orig_sys_document_ref = l_orig_sys_document_ref
1473: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1474: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)