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 1481: FROM oe_price_adjs_iface_all

1477: , nvl( CHANGE_REASON_TEXT, FND_API.G_MISS_CHAR)
1478: , nvl( PRICING_PHASE_ID, FND_API.G_MISS_NUM)
1479: , nvl( ADJUSTED_AMOUNT, FND_API.G_MISS_NUM)
1480: -- Price Adjustment related changes bug# 1220921 (End)
1481: FROM oe_price_adjs_iface_all
1482: WHERE order_source_id = l_order_source_id
1483: AND orig_sys_document_ref = l_orig_sys_document_ref
1484: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1485: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)