APPS.INV_MGD_MVT_DATA_STR dependencies on RCV_TRANSACTIONS

Line 61: parent_transaction_id rcv_transactions.parent_transaction_id%TYPE

57: -- to populate mtl_movement_statistics for transaction type RECEIPT/PO
58:
59: TYPE Receipt_Transaction_Rec_Type IS RECORD
60: (
61: parent_transaction_id rcv_transactions.parent_transaction_id%TYPE
62: , po_release_id rcv_transactions.po_release_id%TYPE
63: , to_organization_id rcv_shipment_lines.to_organization_id%TYPE
64: , mrc_currency_conversion_date
65: rcv_transactions.mrc_currency_conversion_date%TYPE

Line 62: , po_release_id rcv_transactions.po_release_id%TYPE

58:
59: TYPE Receipt_Transaction_Rec_Type IS RECORD
60: (
61: parent_transaction_id rcv_transactions.parent_transaction_id%TYPE
62: , po_release_id rcv_transactions.po_release_id%TYPE
63: , to_organization_id rcv_shipment_lines.to_organization_id%TYPE
64: , mrc_currency_conversion_date
65: rcv_transactions.mrc_currency_conversion_date%TYPE
66: , mrc_currency_conversion_rate

Line 65: rcv_transactions.mrc_currency_conversion_date%TYPE

61: parent_transaction_id rcv_transactions.parent_transaction_id%TYPE
62: , po_release_id rcv_transactions.po_release_id%TYPE
63: , to_organization_id rcv_shipment_lines.to_organization_id%TYPE
64: , mrc_currency_conversion_date
65: rcv_transactions.mrc_currency_conversion_date%TYPE
66: , mrc_currency_conversion_rate
67: rcv_transactions.mrc_currency_conversion_rate%TYPE
68: , mrc_currency_conversion_type
69: rcv_transactions.mrc_currency_conversion_type%TYPE

Line 67: rcv_transactions.mrc_currency_conversion_rate%TYPE

63: , to_organization_id rcv_shipment_lines.to_organization_id%TYPE
64: , mrc_currency_conversion_date
65: rcv_transactions.mrc_currency_conversion_date%TYPE
66: , mrc_currency_conversion_rate
67: rcv_transactions.mrc_currency_conversion_rate%TYPE
68: , mrc_currency_conversion_type
69: rcv_transactions.mrc_currency_conversion_type%TYPE
70: , mrc_po_unit_price NUMBER
71: , primary_unit_of_measure

Line 69: rcv_transactions.mrc_currency_conversion_type%TYPE

65: rcv_transactions.mrc_currency_conversion_date%TYPE
66: , mrc_currency_conversion_rate
67: rcv_transactions.mrc_currency_conversion_rate%TYPE
68: , mrc_currency_conversion_type
69: rcv_transactions.mrc_currency_conversion_type%TYPE
70: , mrc_po_unit_price NUMBER
71: , primary_unit_of_measure
72: rcv_transactions.primary_unit_of_measure%TYPE
73: , uom_code rcv_transactions.uom_code%TYPE

Line 72: rcv_transactions.primary_unit_of_measure%TYPE

68: , mrc_currency_conversion_type
69: rcv_transactions.mrc_currency_conversion_type%TYPE
70: , mrc_po_unit_price NUMBER
71: , primary_unit_of_measure
72: rcv_transactions.primary_unit_of_measure%TYPE
73: , uom_code rcv_transactions.uom_code%TYPE
74: , transaction_type rcv_transactions.transaction_type%TYPE
75: , source_document_code rcv_transactions.source_document_code%TYPE
76: , last_update_date DATE := NULL

Line 73: , uom_code rcv_transactions.uom_code%TYPE

69: rcv_transactions.mrc_currency_conversion_type%TYPE
70: , mrc_po_unit_price NUMBER
71: , primary_unit_of_measure
72: rcv_transactions.primary_unit_of_measure%TYPE
73: , uom_code rcv_transactions.uom_code%TYPE
74: , transaction_type rcv_transactions.transaction_type%TYPE
75: , source_document_code rcv_transactions.source_document_code%TYPE
76: , last_update_date DATE := NULL
77: , last_updated_by NUMBER := NULL

Line 74: , transaction_type rcv_transactions.transaction_type%TYPE

70: , mrc_po_unit_price NUMBER
71: , primary_unit_of_measure
72: rcv_transactions.primary_unit_of_measure%TYPE
73: , uom_code rcv_transactions.uom_code%TYPE
74: , transaction_type rcv_transactions.transaction_type%TYPE
75: , source_document_code rcv_transactions.source_document_code%TYPE
76: , last_update_date DATE := NULL
77: , last_updated_by NUMBER := NULL
78: , last_update_login NUMBER := NULL

Line 75: , source_document_code rcv_transactions.source_document_code%TYPE

71: , primary_unit_of_measure
72: rcv_transactions.primary_unit_of_measure%TYPE
73: , uom_code rcv_transactions.uom_code%TYPE
74: , transaction_type rcv_transactions.transaction_type%TYPE
75: , source_document_code rcv_transactions.source_document_code%TYPE
76: , last_update_date DATE := NULL
77: , last_updated_by NUMBER := NULL
78: , last_update_login NUMBER := NULL
79: );

Line 292: , release_id rcv_transactions.po_release_id%TYPE

288: , transaction_type_id mtl_material_transactions.transaction_type_id%TYPE
289: , transaction_action_id mtl_material_transactions.transaction_action_id%TYPE
290: --, opm_trans_id NUMBER
291: , org_id oe_order_headers_all.org_id%TYPE
292: , release_id rcv_transactions.po_release_id%TYPE
293: , type_lookup_code po_headers_all.type_lookup_code%TYPE
294: , reference_date DATE
295: , consigned_flag rcv_transactions.consigned_flag%TYPE
296: , sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE -- 7165989

Line 295: , consigned_flag rcv_transactions.consigned_flag%TYPE

291: , org_id oe_order_headers_all.org_id%TYPE
292: , release_id rcv_transactions.po_release_id%TYPE
293: , type_lookup_code po_headers_all.type_lookup_code%TYPE
294: , reference_date DATE
295: , consigned_flag rcv_transactions.consigned_flag%TYPE
296: , sold_from_org_id oe_order_headers_all.sold_from_org_id%TYPE -- 7165989
297: );
298:
299: --Bug: 5920143. New column include_establishments has beed added in