[Home] [Help]
807: , nvl(attribute13 , FND_API.G_MISS_CHAR)
808: , nvl(attribute14 , FND_API.G_MISS_CHAR)
809: , nvl(attribute15 , FND_API.G_MISS_CHAR)
810: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)
811: FROM oe_price_atts_iface_all
812: WHERE order_source_id = l_order_source_id
813: AND orig_sys_document_ref = l_orig_sys_document_ref
814: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
815: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)
1632: , nvl(attribute13 , FND_API.G_MISS_CHAR)
1633: , nvl(attribute14 , FND_API.G_MISS_CHAR)
1634: , nvl(attribute15 , FND_API.G_MISS_CHAR)
1635: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)
1636: FROM oe_price_atts_iface_all
1637: WHERE order_source_id = l_order_source_id
1638: AND orig_sys_document_ref = l_orig_sys_document_ref
1639: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
1640: = nvl(l_sold_to_org_id, FND_API.G_MISS_NUM)