DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on QP_LIST_LINES

Line 3987: FROM qp_list_headers_b spl, qp_list_lines SPLL, qp_pricing_attributes qpa

3983: /*Bug: 13566324 Modified the SQL*/
3984:
3985: select SPLL.operand, substr(SPL.currency_code, 1, 15)
3986: INTO l_transfer_price, l_invoice_currency_code
3987: FROM qp_list_headers_b spl, qp_list_lines SPLL, qp_pricing_attributes qpa
3988: WHERE SPL.list_header_id = p_price_list_id
3989: AND SPLL.list_header_id = SPL.list_header_id
3990: AND SPLL.list_line_id = qpa.list_line_id
3991: AND qpa.product_attribute_context = 'ITEM'

Line 4017: FROM QP_LIST_HEADERS_B SPL, QP_LIST_LINES SPLL,

4013: /*Bug: 13566324 Modified the SQL*/
4014:
4015: SELECT SPLL.operand, substr(SPL.currency_code, 1, 15), msi.primary_uom_code
4016: INTO l_transfer_price, l_invoice_currency_code, l_primary_uom
4017: FROM QP_LIST_HEADERS_B SPL, QP_LIST_LINES SPLL,
4018: QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSI
4019: WHERE MSI.organization_id = l_organization_id
4020: AND MSI.inventory_item_id = p_inventory_item_id
4021: AND SPL.list_header_id = p_price_list_id