VIEW: APPS.POA_RTX_BS_V

Source

View Text - Preformatted

SELECT rtx.transaction_id transaction_id, mv.commodity_id commodity_id, mv.category_id category_id, mv.po_item_id po_item_id, mv.org_id org_id, mv.supplier_id supplier_id, mv.supplier_site_id supplier_site_id, mv.buyer_id buyer_id, mv.receiving_org_id receiving_org_id, mv.reason_id reason_id, mv.base_uom base_uom, mv.transaction_type transaction_type, mv.ent_qtr_id ent_qtr_id, mv.ent_period_id ent_period_id, mv.week_id week_id, mv.day_id day_id, mv.mx_id mx_id, mv.quantity quantity, mv.amount_b amount_b, mv.amount_g amount_g, mv.amount_sg amount_sg, mv.amt_afterdue_b amt_afterdue_b, mv.amt_afterdue_g amt_afterdue_g, mv.amt_afterdue_sg amt_afterdue_sg, mv.amt_beforedue_b amt_beforedue_b, mv.amt_beforedue_g amt_beforedue_g, mv.amt_beforedue_sg amt_beforedue_sg, mv.amt_expt_b amt_expt_b, mv.amt_expt_g amt_expt_g, mv.amt_expt_sg amt_expt_sg, (case when (mv.mx_id = 2 and mv.transaction_flag in ('ACCEPT', 'REJECT')) then mv.amount_b end) amt_inspected_b, (case when (mv.mx_id = 2 and mv.transaction_flag in ('ACCEPT', 'REJECT')) then mv.amount_g end) amt_inspected_g, (case when (mv.mx_id = 2 and mv.transaction_flag in ('ACCEPT', 'REJECT')) then mv.amount_sg end) amt_inspected_sg, mv.qty_intol qty_intol, mv.qty_afterdue qty_afterdue, mv.qty_beforedue qty_beforedue, mv.num_days_late num_days_late, mv.num_days_early num_days_early, mv.transaction_flag transaction_flag, mv.dropship_type_code dropship_type_code, rtx.parent_transaction_type parent_transaction_type, rtx.grp_txn_date grp_txn_date, rtx.receive_txn_date receive_txn_date, rtx.transaction_date transaction_date, rtx.rcv_creation_date rcv_creation_date, rtx.func_cur_code func_cur_code, rtx.global_cur_conv_rate global_cur_conv_rate, rtx.sglobal_cur_conv_rate sglobal_cur_conv_rate, rtx.receipt_num receipt_num, rtx.receipt_exists receipt_exists, rtx.currency_conversion_rate currency_conversion_rate, rtx.currency_conversion_date currency_conversion_date, rtx.source_document_code source_document_code, rtx.shipping_control shipping_control, rtx.inventory_item_id inventory_item_id, pll.expected_date expected_date, pll.price_override price_override, pll.matching_basis matching_basis, pll.base_uom_conv_rate base_uom_conv_rate, rcv.unit_of_measure transaction_uom, pll.line_location_id line_location_id from poa_rtx_bs_j_mv mv, poa_dbi_pll_mv pll, poa_dbi_rtx_f rtx, rcv_transactions rcv WHERE mv.prid=pll.rowid and mv.rrid=rtx.rowid and rtx.transaction_id = rcv.transaction_id

View Text - HTML Formatted

SELECT RTX.TRANSACTION_ID TRANSACTION_ID
, MV.COMMODITY_ID COMMODITY_ID
, MV.CATEGORY_ID CATEGORY_ID
, MV.PO_ITEM_ID PO_ITEM_ID
, MV.ORG_ID ORG_ID
, MV.SUPPLIER_ID SUPPLIER_ID
, MV.SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, MV.BUYER_ID BUYER_ID
, MV.RECEIVING_ORG_ID RECEIVING_ORG_ID
, MV.REASON_ID REASON_ID
, MV.BASE_UOM BASE_UOM
, MV.TRANSACTION_TYPE TRANSACTION_TYPE
, MV.ENT_QTR_ID ENT_QTR_ID
, MV.ENT_PERIOD_ID ENT_PERIOD_ID
, MV.WEEK_ID WEEK_ID
, MV.DAY_ID DAY_ID
, MV.MX_ID MX_ID
, MV.QUANTITY QUANTITY
, MV.AMOUNT_B AMOUNT_B
, MV.AMOUNT_G AMOUNT_G
, MV.AMOUNT_SG AMOUNT_SG
, MV.AMT_AFTERDUE_B AMT_AFTERDUE_B
, MV.AMT_AFTERDUE_G AMT_AFTERDUE_G
, MV.AMT_AFTERDUE_SG AMT_AFTERDUE_SG
, MV.AMT_BEFOREDUE_B AMT_BEFOREDUE_B
, MV.AMT_BEFOREDUE_G AMT_BEFOREDUE_G
, MV.AMT_BEFOREDUE_SG AMT_BEFOREDUE_SG
, MV.AMT_EXPT_B AMT_EXPT_B
, MV.AMT_EXPT_G AMT_EXPT_G
, MV.AMT_EXPT_SG AMT_EXPT_SG
, (CASE WHEN (MV.MX_ID = 2
AND MV.TRANSACTION_FLAG IN ('ACCEPT'
, 'REJECT')) THEN MV.AMOUNT_B END) AMT_INSPECTED_B
, (CASE WHEN (MV.MX_ID = 2
AND MV.TRANSACTION_FLAG IN ('ACCEPT'
, 'REJECT')) THEN MV.AMOUNT_G END) AMT_INSPECTED_G
, (CASE WHEN (MV.MX_ID = 2
AND MV.TRANSACTION_FLAG IN ('ACCEPT'
, 'REJECT')) THEN MV.AMOUNT_SG END) AMT_INSPECTED_SG
, MV.QTY_INTOL QTY_INTOL
, MV.QTY_AFTERDUE QTY_AFTERDUE
, MV.QTY_BEFOREDUE QTY_BEFOREDUE
, MV.NUM_DAYS_LATE NUM_DAYS_LATE
, MV.NUM_DAYS_EARLY NUM_DAYS_EARLY
, MV.TRANSACTION_FLAG TRANSACTION_FLAG
, MV.DROPSHIP_TYPE_CODE DROPSHIP_TYPE_CODE
, RTX.PARENT_TRANSACTION_TYPE PARENT_TRANSACTION_TYPE
, RTX.GRP_TXN_DATE GRP_TXN_DATE
, RTX.RECEIVE_TXN_DATE RECEIVE_TXN_DATE
, RTX.TRANSACTION_DATE TRANSACTION_DATE
, RTX.RCV_CREATION_DATE RCV_CREATION_DATE
, RTX.FUNC_CUR_CODE FUNC_CUR_CODE
, RTX.GLOBAL_CUR_CONV_RATE GLOBAL_CUR_CONV_RATE
, RTX.SGLOBAL_CUR_CONV_RATE SGLOBAL_CUR_CONV_RATE
, RTX.RECEIPT_NUM RECEIPT_NUM
, RTX.RECEIPT_EXISTS RECEIPT_EXISTS
, RTX.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, RTX.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, RTX.SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE
, RTX.SHIPPING_CONTROL SHIPPING_CONTROL
, RTX.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PLL.EXPECTED_DATE EXPECTED_DATE
, PLL.PRICE_OVERRIDE PRICE_OVERRIDE
, PLL.MATCHING_BASIS MATCHING_BASIS
, PLL.BASE_UOM_CONV_RATE BASE_UOM_CONV_RATE
, RCV.UNIT_OF_MEASURE TRANSACTION_UOM
, PLL.LINE_LOCATION_ID LINE_LOCATION_ID
FROM POA_RTX_BS_J_MV MV
, POA_DBI_PLL_MV PLL
, POA_DBI_RTX_F RTX
, RCV_TRANSACTIONS RCV
WHERE MV.PRID=PLL.ROWID
AND MV.RRID=RTX.ROWID
AND RTX.TRANSACTION_ID = RCV.TRANSACTION_ID