The following lines contain the word 'select', 'insert', 'update' or 'delete':
g_records_inserted NUMBER := 0;
l_insert_status VARCHAR2(10);
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
COMMIT;
g_records_inserted := g_records_inserted +1;
Update_Invoice_Info
( p_movement_transaction => l_movement_transaction
, p_start_date => p_start_date
, p_end_date => p_end_date
, p_transaction_type => p_source_type
, x_return_status => l_return_status
);
|| '.Failed in Update_Invoice_Info'
,'Failed'
);
Update_PO_With_Correction
( p_legal_entity_id => p_legal_entity_id
, p_start_date => p_start_date
, p_end_date => p_end_date
, p_transaction_type => p_source_type
, x_return_status => l_return_status
);
|| '.Failed in Update_PO_With_Correction'
,'Failed'
);
, '< ***** Records Inserted: '||g_records_inserted
);
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_INV_MDTR.Get_INV_Details
( x_movement_transaction => l_movement_transaction
, x_return_status => l_return_status
);
, x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_INV_MDTR.Update_INV_Transactions
( p_movement_transaction => l_movement_transaction
, x_return_status => l_return_status );
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
SELECT
item_type_code
, NVL(shipped_quantity, fulfilled_quantity)
FROM
oe_order_lines_all
WHERE line_id = l_link_to_line_id;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
||'.The need crt kit,kit rec status,insert flg are '
||l_need_create_kit||','||l_kit_record_status
||','||l_insert_flag
,'debug msg');
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_SO_MDTR.Get_SO_Details
(x_movement_transaction => l_movement_transaction
,x_return_status => l_return_status
);
SELECT mvt_stat_status
INTO l_mvt_stat_status
FROM wsh_delivery_details_ob_grp_v
WHERE delivery_detail_id = l_movement_transaction.picking_line_detail_id;
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
END IF; --< end of IF from l_insert_flag = 'Y' >
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
( p_movement_id => l_movement_transaction.movement_id
, p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
, p_link_to_line_id => l_link_to_line_id
, p_status => l_cross_le_status
, x_return_status => l_return_status
);
INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
( p_movement_transaction => l_movement_transaction
, p_status => l_cross_le_status
, x_return_status => l_return_status
);
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
SELECT
item_type_code
, NVL(shipped_quantity, fulfilled_quantity)
FROM
oe_order_lines_all
WHERE line_id = l_link_to_line_id;
SELECT
transactional_curr_code
, conversion_rate
, conversion_type_code
, conversion_rate_date
FROM oe_order_headers_all
WHERE header_id = l_movement_transaction2.order_header_id;
SELECT
bill_to_site_use_id
FROM
hz_cust_site_uses_all
WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_SO_MDTR.Get_SO_Details
(x_movement_transaction => l_movement_transaction
,x_return_status => l_return_status
);
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction2);
IF l_insert_flag = 'Y'
THEN
--Clear invoice information
l_movement_transaction2.invoice_id := null;
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id2 := l_movement_transaction2.movement_id;
g_records_inserted := g_records_inserted +1;
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
( p_movement_id => l_movement_transaction.movement_id
, p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
, p_link_to_line_id => l_link_to_line_id
, p_status => 'ARRIVALPROCESSED'
, x_return_status => l_return_status
);
INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
( p_movement_transaction => l_movement_transaction
, p_status => 'ARRIVALPROCESSED'
, x_return_status => l_return_status
);
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
SELECT
MAX(oola.line_id)
, MAX(wdd.delivery_detail_id) picking_line_detail_id
, MAX(wdd.organization_id) shipping_organization_id
FROM
oe_order_lines_all oola
, wsh_delivery_details_ob_grp_v wdd
WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
AND oola.orig_sys_document_ref = l_req_number
AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
AND oola.line_id = wdd.source_line_id;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_PO_MDTR.Get_IO_Arrival_Details
( x_movement_transaction => l_movement_transaction
, x_return_status => l_return_status
);
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
END IF; --< end of if from l_insert_flag>
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
( p_movement_transaction => l_movement_transaction
, p_mvt_stat_status => NULL
, x_return_status => l_return_status
);
PROCEDURE Update_PO_With_RTV
( x_mvt_rtv_transaction IN OUT NOCOPY
INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_parent_mvt_id NUMBER;
l_api_name CONSTANT VARCHAR2(30) := 'Update_PO_With_RTV';
SELECT
mms.movement_id
, mms.movement_status
FROM
mtl_movement_statistics mms
, rcv_transactions rt
WHERE mms.rcv_transaction_id = rt.parent_transaction_id
AND rt.transaction_id = x_mvt_rtv_transaction.rcv_transaction_id
AND mms.entity_org_id = x_mvt_rtv_transaction.entity_org_id
AND mms.zone_code = x_mvt_rtv_transaction.zone_code
AND mms.usage_type = x_mvt_rtv_transaction.usage_type
AND mms.stat_type = x_mvt_rtv_transaction.stat_type
AND mms.movement_type <> 'AA';
SELECT
movement_id
, organization_id
, entity_org_id
, movement_type
, movement_status
, transaction_date
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, document_source_type
, creation_method
, document_reference
, document_line_reference
, document_unit_price
, document_line_ext_value
, receipt_reference
, shipment_reference
, shipment_line_reference
, pick_slip_reference
, customer_name
, customer_number
, customer_location
, transacting_from_org
, transacting_to_org
, vendor_name
, vendor_number
, vendor_site
, bill_to_name
, bill_to_number
, bill_to_site
, po_header_id
, po_line_id
, po_line_location_id
, order_header_id
, order_line_id
, picking_line_id
, shipment_header_id
, shipment_line_id
, ship_to_customer_id
, ship_to_site_use_id
, bill_to_customer_id
, bill_to_site_use_id
, vendor_id
, vendor_site_id
, from_organization_id
, to_organization_id
, parent_movement_id
, inventory_item_id
, item_description
, item_cost
, transaction_quantity
, transaction_uom_code
, primary_quantity
, invoice_batch_id
, invoice_id
, customer_trx_line_id
, invoice_batch_reference
, invoice_reference
, invoice_line_reference
, invoice_date_reference
, invoice_quantity
, invoice_unit_price
, invoice_line_ext_value
, outside_code
, outside_ext_value
, outside_unit_price
, currency_code
, currency_conversion_rate
, currency_conversion_type
, currency_conversion_date
, period_name
, report_reference
, report_date
, category_id
, weight_method
, unit_weight
, total_weight
, transaction_nature
, delivery_terms
, transport_mode
, alternate_quantity
, alternate_uom_code
, dispatch_territory_code
, destination_territory_code
, origin_territory_code
, stat_method
, stat_adj_percent
, stat_adj_amount
, stat_ext_value
, area
, port
, stat_type
, comments
, attribute_category
, commodity_code
, commodity_description
, requisition_header_id
, requisition_line_id
, picking_line_detail_id
, usage_type
, zone_code
, edi_sent_flag
, statistical_procedure_code
, movement_amount
, triangulation_country_code
, csa_code
, oil_reference_code
, container_type_code
, flow_indicator_code
, affiliation_reference_code
, origin_territory_eu_code
, destination_territory_eu_code
, dispatch_territory_eu_code
, set_of_books_period
, taric_code
, preference_code
, rcv_transaction_id
, mtl_transaction_id
, total_weight_uom_code
, financial_document_flag
--, opm_trans_id
, customer_vat_number
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, triangulation_country_eu_code
, distribution_line_number
, ship_to_name
, ship_to_number
, ship_to_site
, edi_transaction_date
, edi_transaction_reference
, esl_drop_shipment_code
FROM
mtl_movement_statistics
WHERE movement_id = l_parent_mvt_id;
, l_parent_mvt_transaction.last_update_date
, l_parent_mvt_transaction.last_updated_by
, l_parent_mvt_transaction.creation_date
, l_parent_mvt_transaction.created_by
, l_parent_mvt_transaction.last_update_login
, l_parent_mvt_transaction.document_source_type
, l_parent_mvt_transaction.creation_method
, l_parent_mvt_transaction.document_reference
, l_parent_mvt_transaction.document_line_reference
, l_parent_mvt_transaction.document_unit_price
, l_parent_mvt_transaction.document_line_ext_value
, l_parent_mvt_transaction.receipt_reference
, l_parent_mvt_transaction.shipment_reference
, l_parent_mvt_transaction.shipment_line_reference
, l_parent_mvt_transaction.pick_slip_reference
, l_parent_mvt_transaction.customer_name
, l_parent_mvt_transaction.customer_number
, l_parent_mvt_transaction.customer_location
, l_parent_mvt_transaction.transacting_from_org
, l_parent_mvt_transaction.transacting_to_org
, l_parent_mvt_transaction.vendor_name
, l_parent_mvt_transaction.vendor_number
, l_parent_mvt_transaction.vendor_site
, l_parent_mvt_transaction.bill_to_name
, l_parent_mvt_transaction.bill_to_number
, l_parent_mvt_transaction.bill_to_site
, l_parent_mvt_transaction.po_header_id
, l_parent_mvt_transaction.po_line_id
, l_parent_mvt_transaction.po_line_location_id
, l_parent_mvt_transaction.order_header_id
, l_parent_mvt_transaction.order_line_id
, l_parent_mvt_transaction.picking_line_id
, l_parent_mvt_transaction.shipment_header_id
, l_parent_mvt_transaction.shipment_line_id
, l_parent_mvt_transaction.ship_to_customer_id
, l_parent_mvt_transaction.ship_to_site_use_id
, l_parent_mvt_transaction.bill_to_customer_id
, l_parent_mvt_transaction.bill_to_site_use_id
, l_parent_mvt_transaction.vendor_id
, l_parent_mvt_transaction.vendor_site_id
, l_parent_mvt_transaction.from_organization_id
, l_parent_mvt_transaction.to_organization_id
, l_parent_mvt_transaction.parent_movement_id
, l_parent_mvt_transaction.inventory_item_id
, l_parent_mvt_transaction.item_description
, l_parent_mvt_transaction.item_cost
, l_parent_mvt_transaction.transaction_quantity
, l_parent_mvt_transaction.transaction_uom_code
, l_parent_mvt_transaction.primary_quantity
, l_parent_mvt_transaction.invoice_batch_id
, l_parent_mvt_transaction.invoice_id
, l_parent_mvt_transaction.customer_trx_line_id
, l_parent_mvt_transaction.invoice_batch_reference
, l_parent_mvt_transaction.invoice_reference
, l_parent_mvt_transaction.invoice_line_reference
, l_parent_mvt_transaction.invoice_date_reference
, l_parent_mvt_transaction.invoice_quantity
, l_parent_mvt_transaction.invoice_unit_price
, l_parent_mvt_transaction.invoice_line_ext_value
, l_parent_mvt_transaction.outside_code
, l_parent_mvt_transaction.outside_ext_value
, l_parent_mvt_transaction.outside_unit_price
, l_parent_mvt_transaction.currency_code
, l_parent_mvt_transaction.currency_conversion_rate
, l_parent_mvt_transaction.currency_conversion_type
, l_parent_mvt_transaction.currency_conversion_date
, l_parent_mvt_transaction.period_name
, l_parent_mvt_transaction.report_reference
, l_parent_mvt_transaction.report_date
, l_parent_mvt_transaction.category_id
, l_parent_mvt_transaction.weight_method
, l_parent_mvt_transaction.unit_weight
, l_parent_mvt_transaction.total_weight
, l_parent_mvt_transaction.transaction_nature
, l_parent_mvt_transaction.delivery_terms
, l_parent_mvt_transaction.transport_mode
, l_parent_mvt_transaction.alternate_quantity
, l_parent_mvt_transaction.alternate_uom_code
, l_parent_mvt_transaction.dispatch_territory_code
, l_parent_mvt_transaction.destination_territory_code
, l_parent_mvt_transaction.origin_territory_code
, l_parent_mvt_transaction.stat_method
, l_parent_mvt_transaction.stat_adj_percent
, l_parent_mvt_transaction.stat_adj_amount
, l_parent_mvt_transaction.stat_ext_value
, l_parent_mvt_transaction.area
, l_parent_mvt_transaction.port
, l_parent_mvt_transaction.stat_type
, l_parent_mvt_transaction.comments
, l_parent_mvt_transaction.attribute_category
, l_parent_mvt_transaction.commodity_code
, l_parent_mvt_transaction.commodity_description
, l_parent_mvt_transaction.requisition_header_id
, l_parent_mvt_transaction.requisition_line_id
, l_parent_mvt_transaction.picking_line_detail_id
, l_parent_mvt_transaction.usage_type
, l_parent_mvt_transaction.zone_code
, l_parent_mvt_transaction.edi_sent_flag
, l_parent_mvt_transaction.statistical_procedure_code
, l_parent_mvt_transaction.movement_amount
, l_parent_mvt_transaction.triangulation_country_code
, l_parent_mvt_transaction.csa_code
, l_parent_mvt_transaction.oil_reference_code
, l_parent_mvt_transaction.container_type_code
, l_parent_mvt_transaction.flow_indicator_code
, l_parent_mvt_transaction.affiliation_reference_code
, l_parent_mvt_transaction.origin_territory_eu_code
, l_parent_mvt_transaction.destination_territory_eu_code
, l_parent_mvt_transaction.dispatch_territory_eu_code
, l_parent_mvt_transaction.set_of_books_period
, l_parent_mvt_transaction.taric_code
, l_parent_mvt_transaction.preference_code
, l_parent_mvt_transaction.rcv_transaction_id
, l_parent_mvt_transaction.mtl_transaction_id
, l_parent_mvt_transaction.total_weight_uom_code
, l_parent_mvt_transaction.financial_document_flag
--, l_parent_mvt_transaction.opm_trans_id
, l_parent_mvt_transaction.customer_vat_number
, l_parent_mvt_transaction.attribute1
, l_parent_mvt_transaction.attribute2
, l_parent_mvt_transaction.attribute3
, l_parent_mvt_transaction.attribute4
, l_parent_mvt_transaction.attribute5
, l_parent_mvt_transaction.attribute6
, l_parent_mvt_transaction.attribute7
, l_parent_mvt_transaction.attribute8
, l_parent_mvt_transaction.attribute9
, l_parent_mvt_transaction.attribute10
, l_parent_mvt_transaction.attribute11
, l_parent_mvt_transaction.attribute12
, l_parent_mvt_transaction.attribute13
, l_parent_mvt_transaction.attribute14
, l_parent_mvt_transaction.attribute15
, l_parent_mvt_transaction.triangulation_country_eu_code
, l_parent_mvt_transaction.distribution_line_number
, l_parent_mvt_transaction.ship_to_name
, l_parent_mvt_transaction.ship_to_number
, l_parent_mvt_transaction.ship_to_site
, l_parent_mvt_transaction.edi_transaction_date
, l_parent_mvt_transaction.edi_transaction_reference
, l_parent_mvt_transaction.esl_drop_shipment_code;
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
( p_movement_statistics => l_parent_mvt_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Update_PO_With_RTV;
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
l_update_status VARCHAR2(1);
SELECT
drop_ship_source_id
FROM
OE_DROP_SHIP_SOURCES
WHERE po_header_id = l_movement_transaction.po_header_id
AND po_line_id = l_movement_transaction.po_line_id
AND line_location_id = l_movement_transaction.po_line_location_id;
SELECT
vendor_site_id
FROM
po_headers_all
WHERE po_header_id = l_movement_transaction.po_header_id;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
l_update_status := 'N';
IF (NVL(l_insert_flag,'N') = 'Y'
AND l_par_mvt_id IS NOT NULL
AND l_par_movement_status IN ('F','X'))
THEN
l_insert_flag := 'Y';
l_insert_flag := 'N';
l_update_status := 'N';
l_update_status := 'Y';
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_PO_MDTR.Get_PO_Details
(p_stat_typ_transaction => l_stat_typ_transaction
,x_movement_transaction => l_movement_transaction
,x_return_status => l_return_status
);
Update_PO_With_RTV
( x_mvt_rtv_transaction => l_movement_transaction
, x_return_status => l_insert_status
);
,x_return_status => l_insert_status
);
IF l_insert_status = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
l_insert_flag := 'N';
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
(p_stat_typ_transaction => l_stat_typ_transaction
,x_movement_transaction => l_movement_transaction
,x_return_status => l_return_status
);
g_records_inserted := g_records_inserted +1;
END IF; -- end l_insert_flag
END IF; -- < end insert>
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
l_insert_flag := 'N';
l_insert_flag := 'N';
IF l_insert_flag = 'Y'
THEN
INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
(p_stat_typ_transaction => l_stat_typ_transaction
,x_movement_transaction => l_movement_transaction
,x_return_status => l_return_status
);
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) =
FND_API.G_RET_STS_SUCCESS
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
END IF; --end insert flag Y
END IF; --end if for l_insert_flag
IF (NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
OR l_update_status = 'Y')
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
( p_movement_transaction => l_movement_transaction
, p_mvt_stat_status => NULL
, x_return_status => l_return_status
);
PROCEDURE Update_SO_With_RMA
( x_mvt_rma_transaction IN OUT NOCOPY
INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_parent_mvt_id NUMBER;
l_api_name CONSTANT VARCHAR2(30) := 'Update_SO_With_RMA';
SELECT
mms.movement_id
, mms.movement_status
FROM
mtl_movement_statistics mms
, oe_order_lines_all oola
WHERE mms.order_header_id = oola.reference_header_id
AND mms.order_line_id = oola.reference_line_id
AND oola.line_id = x_mvt_rma_transaction.order_line_id
AND mms.entity_org_id = x_mvt_rma_transaction.entity_org_id
AND mms.zone_code = x_mvt_rma_transaction.zone_code
AND mms.usage_type = x_mvt_rma_transaction.usage_type
AND mms.stat_type = x_mvt_rma_transaction.stat_type
AND mms.movement_type <> 'DA';
SELECT
movement_id
, organization_id
, entity_org_id
, movement_type
, movement_status
, transaction_date
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, document_source_type
, creation_method
, document_reference
, document_line_reference
, document_unit_price
, document_line_ext_value
, receipt_reference
, shipment_reference
, shipment_line_reference
, pick_slip_reference
, customer_name
, customer_number
, customer_location
, transacting_from_org
, transacting_to_org
, vendor_name
, vendor_number
, vendor_site
, bill_to_name
, bill_to_number
, bill_to_site
, po_header_id
, po_line_id
, po_line_location_id
, order_header_id
, order_line_id
, picking_line_id
, shipment_header_id
, shipment_line_id
, ship_to_customer_id
, ship_to_site_use_id
, bill_to_customer_id
, bill_to_site_use_id
, vendor_id
, vendor_site_id
, from_organization_id
, to_organization_id
, parent_movement_id
, inventory_item_id
, item_description
, item_cost
, transaction_quantity
, transaction_uom_code
, primary_quantity
, invoice_batch_id
, invoice_id
, customer_trx_line_id
, invoice_batch_reference
, invoice_reference
, invoice_line_reference
, invoice_date_reference
, invoice_quantity
, invoice_unit_price
, invoice_line_ext_value
, outside_code
, outside_ext_value
, outside_unit_price
, currency_code
, currency_conversion_rate
, currency_conversion_type
, currency_conversion_date
, period_name
, report_reference
, report_date
, category_id
, weight_method
, unit_weight
, total_weight
, transaction_nature
, delivery_terms
, transport_mode
, alternate_quantity
, alternate_uom_code
, dispatch_territory_code
, destination_territory_code
, origin_territory_code
, stat_method
, stat_adj_percent
, stat_adj_amount
, stat_ext_value
, area
, port
, stat_type
, comments
, attribute_category
, commodity_code
, commodity_description
, requisition_header_id
, requisition_line_id
, picking_line_detail_id
, usage_type
, zone_code
, edi_sent_flag
, statistical_procedure_code
, movement_amount
, triangulation_country_code
, csa_code
, oil_reference_code
, container_type_code
, flow_indicator_code
, affiliation_reference_code
, origin_territory_eu_code
, destination_territory_eu_code
, dispatch_territory_eu_code
, set_of_books_period
, taric_code
, preference_code
, rcv_transaction_id
, mtl_transaction_id
, total_weight_uom_code
, financial_document_flag
--, opm_trans_id
, customer_vat_number
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, triangulation_country_eu_code
, distribution_line_number
, ship_to_name
, ship_to_number
, ship_to_site
, edi_transaction_date
, edi_transaction_reference
, esl_drop_shipment_code
FROM
mtl_movement_statistics
WHERE movement_id = l_parent_mvt_id;
, l_parent_mvt_transaction.last_update_date
, l_parent_mvt_transaction.last_updated_by
, l_parent_mvt_transaction.creation_date
, l_parent_mvt_transaction.created_by
, l_parent_mvt_transaction.last_update_login
, l_parent_mvt_transaction.document_source_type
, l_parent_mvt_transaction.creation_method
, l_parent_mvt_transaction.document_reference
, l_parent_mvt_transaction.document_line_reference
, l_parent_mvt_transaction.document_unit_price
, l_parent_mvt_transaction.document_line_ext_value
, l_parent_mvt_transaction.receipt_reference
, l_parent_mvt_transaction.shipment_reference
, l_parent_mvt_transaction.shipment_line_reference
, l_parent_mvt_transaction.pick_slip_reference
, l_parent_mvt_transaction.customer_name
, l_parent_mvt_transaction.customer_number
, l_parent_mvt_transaction.customer_location
, l_parent_mvt_transaction.transacting_from_org
, l_parent_mvt_transaction.transacting_to_org
, l_parent_mvt_transaction.vendor_name
, l_parent_mvt_transaction.vendor_number
, l_parent_mvt_transaction.vendor_site
, l_parent_mvt_transaction.bill_to_name
, l_parent_mvt_transaction.bill_to_number
, l_parent_mvt_transaction.bill_to_site
, l_parent_mvt_transaction.po_header_id
, l_parent_mvt_transaction.po_line_id
, l_parent_mvt_transaction.po_line_location_id
, l_parent_mvt_transaction.order_header_id
, l_parent_mvt_transaction.order_line_id
, l_parent_mvt_transaction.picking_line_id
, l_parent_mvt_transaction.shipment_header_id
, l_parent_mvt_transaction.shipment_line_id
, l_parent_mvt_transaction.ship_to_customer_id
, l_parent_mvt_transaction.ship_to_site_use_id
, l_parent_mvt_transaction.bill_to_customer_id
, l_parent_mvt_transaction.bill_to_site_use_id
, l_parent_mvt_transaction.vendor_id
, l_parent_mvt_transaction.vendor_site_id
, l_parent_mvt_transaction.from_organization_id
, l_parent_mvt_transaction.to_organization_id
, l_parent_mvt_transaction.parent_movement_id
, l_parent_mvt_transaction.inventory_item_id
, l_parent_mvt_transaction.item_description
, l_parent_mvt_transaction.item_cost
, l_parent_mvt_transaction.transaction_quantity
, l_parent_mvt_transaction.transaction_uom_code
, l_parent_mvt_transaction.primary_quantity
, l_parent_mvt_transaction.invoice_batch_id
, l_parent_mvt_transaction.invoice_id
, l_parent_mvt_transaction.customer_trx_line_id
, l_parent_mvt_transaction.invoice_batch_reference
, l_parent_mvt_transaction.invoice_reference
, l_parent_mvt_transaction.invoice_line_reference
, l_parent_mvt_transaction.invoice_date_reference
, l_parent_mvt_transaction.invoice_quantity
, l_parent_mvt_transaction.invoice_unit_price
, l_parent_mvt_transaction.invoice_line_ext_value
, l_parent_mvt_transaction.outside_code
, l_parent_mvt_transaction.outside_ext_value
, l_parent_mvt_transaction.outside_unit_price
, l_parent_mvt_transaction.currency_code
, l_parent_mvt_transaction.currency_conversion_rate
, l_parent_mvt_transaction.currency_conversion_type
, l_parent_mvt_transaction.currency_conversion_date
, l_parent_mvt_transaction.period_name
, l_parent_mvt_transaction.report_reference
, l_parent_mvt_transaction.report_date
, l_parent_mvt_transaction.category_id
, l_parent_mvt_transaction.weight_method
, l_parent_mvt_transaction.unit_weight
, l_parent_mvt_transaction.total_weight
, l_parent_mvt_transaction.transaction_nature
, l_parent_mvt_transaction.delivery_terms
, l_parent_mvt_transaction.transport_mode
, l_parent_mvt_transaction.alternate_quantity
, l_parent_mvt_transaction.alternate_uom_code
, l_parent_mvt_transaction.dispatch_territory_code
, l_parent_mvt_transaction.destination_territory_code
, l_parent_mvt_transaction.origin_territory_code
, l_parent_mvt_transaction.stat_method
, l_parent_mvt_transaction.stat_adj_percent
, l_parent_mvt_transaction.stat_adj_amount
, l_parent_mvt_transaction.stat_ext_value
, l_parent_mvt_transaction.area
, l_parent_mvt_transaction.port
, l_parent_mvt_transaction.stat_type
, l_parent_mvt_transaction.comments
, l_parent_mvt_transaction.attribute_category
, l_parent_mvt_transaction.commodity_code
, l_parent_mvt_transaction.commodity_description
, l_parent_mvt_transaction.requisition_header_id
, l_parent_mvt_transaction.requisition_line_id
, l_parent_mvt_transaction.picking_line_detail_id
, l_parent_mvt_transaction.usage_type
, l_parent_mvt_transaction.zone_code
, l_parent_mvt_transaction.edi_sent_flag
, l_parent_mvt_transaction.statistical_procedure_code
, l_parent_mvt_transaction.movement_amount
, l_parent_mvt_transaction.triangulation_country_code
, l_parent_mvt_transaction.csa_code
, l_parent_mvt_transaction.oil_reference_code
, l_parent_mvt_transaction.container_type_code
, l_parent_mvt_transaction.flow_indicator_code
, l_parent_mvt_transaction.affiliation_reference_code
, l_parent_mvt_transaction.origin_territory_eu_code
, l_parent_mvt_transaction.destination_territory_eu_code
, l_parent_mvt_transaction.dispatch_territory_eu_code
, l_parent_mvt_transaction.set_of_books_period
, l_parent_mvt_transaction.taric_code
, l_parent_mvt_transaction.preference_code
, l_parent_mvt_transaction.rcv_transaction_id
, l_parent_mvt_transaction.mtl_transaction_id
, l_parent_mvt_transaction.total_weight_uom_code
, l_parent_mvt_transaction.financial_document_flag
--, l_parent_mvt_transaction.opm_trans_id
, l_parent_mvt_transaction.customer_vat_number
, l_parent_mvt_transaction.attribute1
, l_parent_mvt_transaction.attribute2
, l_parent_mvt_transaction.attribute3
, l_parent_mvt_transaction.attribute4
, l_parent_mvt_transaction.attribute5
, l_parent_mvt_transaction.attribute6
, l_parent_mvt_transaction.attribute7
, l_parent_mvt_transaction.attribute8
, l_parent_mvt_transaction.attribute9
, l_parent_mvt_transaction.attribute10
, l_parent_mvt_transaction.attribute11
, l_parent_mvt_transaction.attribute12
, l_parent_mvt_transaction.attribute13
, l_parent_mvt_transaction.attribute14
, l_parent_mvt_transaction.attribute15
, l_parent_mvt_transaction.triangulation_country_eu_code
, l_parent_mvt_transaction.distribution_line_number
, l_parent_mvt_transaction.ship_to_name
, l_parent_mvt_transaction.ship_to_number
, l_parent_mvt_transaction.ship_to_site
, l_parent_mvt_transaction.edi_transaction_date
, l_parent_mvt_transaction.edi_transaction_reference
, l_parent_mvt_transaction.esl_drop_shipment_code;
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
( p_movement_statistics => l_parent_mvt_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Update_SO_With_RMA;
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
l_insert VARCHAR2(1);-- 7165989
SELECT
oola2.item_type_code
FROM
oe_order_lines_all oola1
, oe_order_lines_all oola2
WHERE oola1.line_id = l_movement_transaction.order_line_id
AND oola2.line_id = oola1.reference_line_id;
SELECT ooha.order_number order_number
INTO l_movement_transaction.order_number
FROM OE_ORDER_HEADERS_ALL ooha
WHERE ooha.header_id= l_movement_transaction.order_header_id;
l_insert_flag := 'N';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF (l_insert_flag = 'Y' ) THEN
Process_RMA_Triangulation
( p_movement_transaction => l_movement_transaction
, p_stat_typ_transaction => l_stat_typ_transaction
, x_return_status => x_return_status
);
FND_FILE.put_line (FND_FILE.log ,'mvt stat status after update'||l_mvt_stat_status );
ELSIF (l_insert_flag = 'N') THEN
l_dispatch :=
INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
l_insert := 'Y';
l_insert := 'N';
l_insert_flag := 'N';
l_insert := 'Y';
l_insert := 'N';
l_insert := 'N';
if (l_insert = 'Y') THEN
Process_RMA_Triangulation
( p_movement_transaction => l_movement_transaction
, p_stat_typ_transaction => l_stat_typ_transaction
, x_return_status => x_return_status
);
FND_FILE.put_line (FND_FILE.log ,'mvt stat status after update'||l_mvt_stat_status );
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF (l_insert_flag = 'Y') THEN
IF (l_mvt_stat_status is NOT NULL AND l_mvt_stat_status = 'NEW') THEN
l_mvt_stat_status := 'FORDISP';
l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
( p_movement_transaction => l_movement_transaction);
IF (l_insert_flag = 'Y'
AND l_return_status = 'Y')
THEN
l_process_flag := 'Y';
Update_SO_With_RMA
( x_mvt_rma_transaction => l_movement_transaction
, x_return_status => l_insert_status
);
,x_return_status => l_insert_status
);
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
AND l_movement_transaction.movement_id IS NOT NULL
THEN
l_movement_id := l_movement_transaction.movement_id;
g_records_inserted := g_records_inserted +1;
IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
THEN
l_movement_transaction.movement_id := l_movement_id;
INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
( p_movement_transaction => l_movement_transaction
, p_mvt_stat_status => l_mvt_stat_status /* 7165989 - Pass the appropriate mvt_stat_status for RMA triangulation txns */
, x_return_status => l_return_status
);
PROCEDURE Update_Invoice_Info
( p_movement_transaction IN
INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, p_start_date IN DATE
, p_end_date IN DATE
, p_transaction_type IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
)
IS
-- Declare the REF Cursor
inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
l_api_name CONSTANT VARCHAR2(30) := 'Update_Invoice_Info';
, l_movement_transaction.last_update_date
, l_movement_transaction.last_updated_by
, l_movement_transaction.creation_date
, l_movement_transaction.created_by
, l_movement_transaction.last_update_login
, l_movement_transaction.document_source_type
, l_movement_transaction.creation_method
, l_movement_transaction.document_reference
, l_movement_transaction.document_line_reference
, l_movement_transaction.document_unit_price
, l_movement_transaction.document_line_ext_value
, l_movement_transaction.receipt_reference
, l_movement_transaction.shipment_reference
, l_movement_transaction.shipment_line_reference
, l_movement_transaction.pick_slip_reference
, l_movement_transaction.customer_name
, l_movement_transaction.customer_number
, l_movement_transaction.customer_location
, l_movement_transaction.transacting_from_org
, l_movement_transaction.transacting_to_org
, l_movement_transaction.vendor_name
, l_movement_transaction.vendor_number
, l_movement_transaction.vendor_site
, l_movement_transaction.bill_to_name
, l_movement_transaction.bill_to_number
, l_movement_transaction.bill_to_site
, l_movement_transaction.po_header_id
, l_movement_transaction.po_line_id
, l_movement_transaction.po_line_location_id
, l_movement_transaction.order_header_id
, l_movement_transaction.order_line_id
, l_movement_transaction.picking_line_id
, l_movement_transaction.shipment_header_id
, l_movement_transaction.shipment_line_id
, l_movement_transaction.ship_to_customer_id
, l_movement_transaction.ship_to_site_use_id
, l_movement_transaction.bill_to_customer_id
, l_movement_transaction.bill_to_site_use_id
, l_movement_transaction.vendor_id
, l_movement_transaction.vendor_site_id
, l_movement_transaction.from_organization_id
, l_movement_transaction.to_organization_id
, l_movement_transaction.parent_movement_id
, l_movement_transaction.inventory_item_id
, l_movement_transaction.item_description
, l_movement_transaction.item_cost
, l_movement_transaction.transaction_quantity
, l_movement_transaction.transaction_uom_code
, l_movement_transaction.primary_quantity
, l_movement_transaction.invoice_batch_id
, l_movement_transaction.invoice_id
, l_movement_transaction.customer_trx_line_id
, l_movement_transaction.invoice_batch_reference
, l_movement_transaction.invoice_reference
, l_movement_transaction.invoice_line_reference
, l_movement_transaction.invoice_date_reference
, l_movement_transaction.invoice_quantity
, l_movement_transaction.invoice_unit_price
, l_movement_transaction.invoice_line_ext_value
, l_movement_transaction.outside_code
, l_movement_transaction.outside_ext_value
, l_movement_transaction.outside_unit_price
, l_movement_transaction.currency_code
, l_movement_transaction.currency_conversion_rate
, l_movement_transaction.currency_conversion_type
, l_movement_transaction.currency_conversion_date
, l_movement_transaction.period_name
, l_movement_transaction.report_reference
, l_movement_transaction.report_date
, l_movement_transaction.category_id
, l_movement_transaction.weight_method
, l_movement_transaction.unit_weight
, l_movement_transaction.total_weight
, l_movement_transaction.transaction_nature
, l_movement_transaction.delivery_terms
, l_movement_transaction.transport_mode
, l_movement_transaction.alternate_quantity
, l_movement_transaction.alternate_uom_code
, l_movement_transaction.dispatch_territory_code
, l_movement_transaction.destination_territory_code
, l_movement_transaction.origin_territory_code
, l_movement_transaction.stat_method
, l_movement_transaction.stat_adj_percent
, l_movement_transaction.stat_adj_amount
, l_movement_transaction.stat_ext_value
, l_movement_transaction.area
, l_movement_transaction.port
, l_movement_transaction.stat_type
, l_movement_transaction.comments
, l_movement_transaction.attribute_category
, l_movement_transaction.commodity_code
, l_movement_transaction.commodity_description
, l_movement_transaction.requisition_header_id
, l_movement_transaction.requisition_line_id
, l_movement_transaction.picking_line_detail_id
, l_movement_transaction.usage_type
, l_movement_transaction.zone_code
, l_movement_transaction.edi_sent_flag
, l_movement_transaction.statistical_procedure_code
, l_movement_transaction.movement_amount
, l_movement_transaction.triangulation_country_code
, l_movement_transaction.csa_code
, l_movement_transaction.oil_reference_code
, l_movement_transaction.container_type_code
, l_movement_transaction.flow_indicator_code
, l_movement_transaction.affiliation_reference_code
, l_movement_transaction.origin_territory_eu_code
, l_movement_transaction.destination_territory_eu_code
, l_movement_transaction.dispatch_territory_eu_code
, l_movement_transaction.set_of_books_period
, l_movement_transaction.taric_code
, l_movement_transaction.preference_code
, l_movement_transaction.rcv_transaction_id
, l_movement_transaction.mtl_transaction_id
, l_movement_transaction.total_weight_uom_code
, l_movement_transaction.financial_document_flag
--, l_movement_transaction.opm_trans_id
, l_movement_transaction.customer_vat_number
, l_movement_transaction.attribute1
, l_movement_transaction.attribute2
, l_movement_transaction.attribute3
, l_movement_transaction.attribute4
, l_movement_transaction.attribute5
, l_movement_transaction.attribute6
, l_movement_transaction.attribute7
, l_movement_transaction.attribute8
, l_movement_transaction.attribute9
, l_movement_transaction.attribute10
, l_movement_transaction.attribute11
, l_movement_transaction.attribute12
, l_movement_transaction.attribute13
, l_movement_transaction.attribute14
, l_movement_transaction.attribute15
, l_movement_transaction.triangulation_country_eu_code
, l_movement_transaction.distribution_line_number
, l_movement_transaction.ship_to_name
, l_movement_transaction.ship_to_number
, l_movement_transaction.ship_to_site
, l_movement_transaction.edi_transaction_date
, l_movement_transaction.edi_transaction_reference
, l_movement_transaction.esl_drop_shipment_code;
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
(p_movement_statistics => l_movement_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
END Update_Invoice_Info;
PROCEDURE Update_PO_With_Correction
( p_legal_entity_id IN NUMBER
, p_start_date IN DATE
, p_end_date IN DATE
, p_transaction_type IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
)
IS
-- Declare the REF Cursor
inv_crsr INV_MGD_MVT_DATA_STR.invCurTyp;
l_api_name CONSTANT VARCHAR2(30) := 'Update_PO_With_Correction';
SELECT
SUM(quantity)
, SUM(primary_quantity)
FROM
rcv_transactions
WHERE parent_transaction_id = l_movement_transaction.rcv_transaction_id
AND mvt_stat_status = 'NEW'
AND transaction_type = 'CORRECT';
, l_movement_transaction.last_update_date
, l_movement_transaction.last_updated_by
, l_movement_transaction.creation_date
, l_movement_transaction.created_by
, l_movement_transaction.last_update_login
, l_movement_transaction.document_source_type
, l_movement_transaction.creation_method
, l_movement_transaction.document_reference
, l_movement_transaction.document_line_reference
, l_movement_transaction.document_unit_price
, l_movement_transaction.document_line_ext_value
, l_movement_transaction.receipt_reference
, l_movement_transaction.shipment_reference
, l_movement_transaction.shipment_line_reference
, l_movement_transaction.pick_slip_reference
, l_movement_transaction.customer_name
, l_movement_transaction.customer_number
, l_movement_transaction.customer_location
, l_movement_transaction.transacting_from_org
, l_movement_transaction.transacting_to_org
, l_movement_transaction.vendor_name
, l_movement_transaction.vendor_number
, l_movement_transaction.vendor_site
, l_movement_transaction.bill_to_name
, l_movement_transaction.bill_to_number
, l_movement_transaction.bill_to_site
, l_movement_transaction.po_header_id
, l_movement_transaction.po_line_id
, l_movement_transaction.po_line_location_id
, l_movement_transaction.order_header_id
, l_movement_transaction.order_line_id
, l_movement_transaction.picking_line_id
, l_movement_transaction.shipment_header_id
, l_movement_transaction.shipment_line_id
, l_movement_transaction.ship_to_customer_id
, l_movement_transaction.ship_to_site_use_id
, l_movement_transaction.bill_to_customer_id
, l_movement_transaction.bill_to_site_use_id
, l_movement_transaction.vendor_id
, l_movement_transaction.vendor_site_id
, l_movement_transaction.from_organization_id
, l_movement_transaction.to_organization_id
, l_movement_transaction.parent_movement_id
, l_movement_transaction.inventory_item_id
, l_movement_transaction.item_description
, l_movement_transaction.item_cost
, l_movement_transaction.transaction_quantity
, l_movement_transaction.transaction_uom_code
, l_movement_transaction.primary_quantity
, l_movement_transaction.invoice_batch_id
, l_movement_transaction.invoice_id
, l_movement_transaction.customer_trx_line_id
, l_movement_transaction.invoice_batch_reference
, l_movement_transaction.invoice_reference
, l_movement_transaction.invoice_line_reference
, l_movement_transaction.invoice_date_reference
, l_movement_transaction.invoice_quantity
, l_movement_transaction.invoice_unit_price
, l_movement_transaction.invoice_line_ext_value
, l_movement_transaction.outside_code
, l_movement_transaction.outside_ext_value
, l_movement_transaction.outside_unit_price
, l_movement_transaction.currency_code
, l_movement_transaction.currency_conversion_rate
, l_movement_transaction.currency_conversion_type
, l_movement_transaction.currency_conversion_date
, l_movement_transaction.period_name
, l_movement_transaction.report_reference
, l_movement_transaction.report_date
, l_movement_transaction.category_id
, l_movement_transaction.weight_method
, l_movement_transaction.unit_weight
, l_movement_transaction.total_weight
, l_movement_transaction.transaction_nature
, l_movement_transaction.delivery_terms
, l_movement_transaction.transport_mode
, l_movement_transaction.alternate_quantity
, l_movement_transaction.alternate_uom_code
, l_movement_transaction.dispatch_territory_code
, l_movement_transaction.destination_territory_code
, l_movement_transaction.origin_territory_code
, l_movement_transaction.stat_method
, l_movement_transaction.stat_adj_percent
, l_movement_transaction.stat_adj_amount
, l_movement_transaction.stat_ext_value
, l_movement_transaction.area
, l_movement_transaction.port
, l_movement_transaction.stat_type
, l_movement_transaction.comments
, l_movement_transaction.attribute_category
, l_movement_transaction.commodity_code
, l_movement_transaction.commodity_description
, l_movement_transaction.requisition_header_id
, l_movement_transaction.requisition_line_id
, l_movement_transaction.picking_line_detail_id
, l_movement_transaction.usage_type
, l_movement_transaction.zone_code
, l_movement_transaction.edi_sent_flag
, l_movement_transaction.statistical_procedure_code
, l_movement_transaction.movement_amount
, l_movement_transaction.triangulation_country_code
, l_movement_transaction.csa_code
, l_movement_transaction.oil_reference_code
, l_movement_transaction.container_type_code
, l_movement_transaction.flow_indicator_code
, l_movement_transaction.affiliation_reference_code
, l_movement_transaction.origin_territory_eu_code
, l_movement_transaction.destination_territory_eu_code
, l_movement_transaction.dispatch_territory_eu_code
, l_movement_transaction.set_of_books_period
, l_movement_transaction.taric_code
, l_movement_transaction.preference_code
, l_movement_transaction.rcv_transaction_id
, l_movement_transaction.mtl_transaction_id
, l_movement_transaction.total_weight_uom_code
, l_movement_transaction.financial_document_flag
--, l_movement_transaction.opm_trans_id
, l_movement_transaction.customer_vat_number
, l_movement_transaction.attribute1
, l_movement_transaction.attribute2
, l_movement_transaction.attribute3
, l_movement_transaction.attribute4
, l_movement_transaction.attribute5
, l_movement_transaction.attribute6
, l_movement_transaction.attribute7
, l_movement_transaction.attribute8
, l_movement_transaction.attribute9
, l_movement_transaction.attribute10
, l_movement_transaction.attribute11
, l_movement_transaction.attribute12
, l_movement_transaction.attribute13
, l_movement_transaction.attribute14
, l_movement_transaction.attribute15
, l_movement_transaction.triangulation_country_eu_code
, l_movement_transaction.distribution_line_number
, l_movement_transaction.ship_to_name
, l_movement_transaction.ship_to_number
, l_movement_transaction.ship_to_site
, l_movement_transaction.edi_transaction_date
, l_movement_transaction.edi_transaction_reference
, l_movement_transaction.esl_drop_shipment_code;
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
( p_movement_statistics => l_movement_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
UPDATE rcv_transactions
SET
mvt_stat_status = 'PROCESSED'
, movement_id = l_movement_transaction.movement_id
WHERE mvt_stat_status = 'NEW'
AND transaction_type = 'CORRECT'
AND parent_transaction_id = l_movement_transaction.rcv_transaction_id;
END Update_PO_With_Correction;
l_insert_flag VARCHAR2(1);
l_insert_status VARCHAR2(10);
, l_movement_transaction.last_update_date
, l_movement_transaction.last_updated_by
, l_movement_transaction.creation_date
, l_movement_transaction.created_by
, l_movement_transaction.last_update_login
, l_movement_transaction.document_source_type
, l_movement_transaction.creation_method
, l_movement_transaction.document_reference
, l_movement_transaction.document_line_reference
, l_movement_transaction.document_unit_price
, l_movement_transaction.document_line_ext_value
, l_movement_transaction.receipt_reference
, l_movement_transaction.shipment_reference
, l_movement_transaction.shipment_line_reference
, l_movement_transaction.pick_slip_reference
, l_movement_transaction.customer_name
, l_movement_transaction.customer_number
, l_movement_transaction.customer_location
, l_movement_transaction.transacting_from_org
, l_movement_transaction.transacting_to_org
, l_movement_transaction.vendor_name
, l_movement_transaction.vendor_number
, l_movement_transaction.vendor_site
, l_movement_transaction.bill_to_name
, l_movement_transaction.bill_to_number
, l_movement_transaction.bill_to_site
, l_movement_transaction.po_header_id
, l_movement_transaction.po_line_id
, l_movement_transaction.po_line_location_id
, l_movement_transaction.order_header_id
, l_movement_transaction.order_line_id
, l_movement_transaction.picking_line_id
, l_movement_transaction.shipment_header_id
, l_movement_transaction.shipment_line_id
, l_movement_transaction.ship_to_customer_id
, l_movement_transaction.ship_to_site_use_id
, l_movement_transaction.bill_to_customer_id
, l_movement_transaction.bill_to_site_use_id
, l_movement_transaction.vendor_id
, l_movement_transaction.vendor_site_id
, l_movement_transaction.from_organization_id
, l_movement_transaction.to_organization_id
, l_movement_transaction.parent_movement_id
, l_movement_transaction.inventory_item_id
, l_movement_transaction.item_description
, l_movement_transaction.item_cost
, l_movement_transaction.transaction_quantity
, l_movement_transaction.transaction_uom_code
, l_movement_transaction.primary_quantity
, l_movement_transaction.invoice_batch_id
, l_movement_transaction.invoice_id
, l_movement_transaction.customer_trx_line_id
, l_movement_transaction.invoice_batch_reference
, l_movement_transaction.invoice_reference
, l_movement_transaction.invoice_line_reference
, l_movement_transaction.invoice_date_reference
, l_movement_transaction.invoice_quantity
, l_movement_transaction.invoice_unit_price
, l_movement_transaction.invoice_line_ext_value
, l_movement_transaction.outside_code
, l_movement_transaction.outside_ext_value
, l_movement_transaction.outside_unit_price
, l_movement_transaction.currency_code
, l_movement_transaction.currency_conversion_rate
, l_movement_transaction.currency_conversion_type
, l_movement_transaction.currency_conversion_date
, l_movement_transaction.period_name
, l_movement_transaction.report_reference
, l_movement_transaction.report_date
, l_movement_transaction.category_id
, l_movement_transaction.weight_method
, l_movement_transaction.unit_weight
, l_movement_transaction.total_weight
, l_movement_transaction.transaction_nature
, l_movement_transaction.delivery_terms
, l_movement_transaction.transport_mode
, l_movement_transaction.alternate_quantity
, l_movement_transaction.alternate_uom_code
, l_movement_transaction.dispatch_territory_code
, l_movement_transaction.destination_territory_code
, l_movement_transaction.origin_territory_code
, l_movement_transaction.stat_method
, l_movement_transaction.stat_adj_percent
, l_movement_transaction.stat_adj_amount
, l_movement_transaction.stat_ext_value
, l_movement_transaction.area
, l_movement_transaction.port
, l_movement_transaction.stat_type
, l_movement_transaction.comments
, l_movement_transaction.attribute_category
, l_movement_transaction.commodity_code
, l_movement_transaction.commodity_description
, l_movement_transaction.requisition_header_id
, l_movement_transaction.requisition_line_id
, l_movement_transaction.picking_line_detail_id
, l_movement_transaction.usage_type
, l_movement_transaction.zone_code
, l_movement_transaction.edi_sent_flag
, l_movement_transaction.statistical_procedure_code
, l_movement_transaction.movement_amount
, l_movement_transaction.triangulation_country_code
, l_movement_transaction.csa_code
, l_movement_transaction.oil_reference_code
, l_movement_transaction.container_type_code
, l_movement_transaction.flow_indicator_code
, l_movement_transaction.affiliation_reference_code
, l_movement_transaction.origin_territory_eu_code
, l_movement_transaction.destination_territory_eu_code
, l_movement_transaction.dispatch_territory_eu_code
, l_movement_transaction.set_of_books_period
, l_movement_transaction.taric_code
, l_movement_transaction.preference_code
, l_movement_transaction.rcv_transaction_id
, l_movement_transaction.mtl_transaction_id
, l_movement_transaction.total_weight_uom_code
, l_movement_transaction.financial_document_flag
--, l_movement_transaction.opm_trans_id
, l_movement_transaction.customer_vat_number
, l_movement_transaction.attribute1
, l_movement_transaction.attribute2
, l_movement_transaction.attribute3
, l_movement_transaction.attribute4
, l_movement_transaction.attribute5
, l_movement_transaction.attribute6
, l_movement_transaction.attribute7
, l_movement_transaction.attribute8
, l_movement_transaction.attribute9
, l_movement_transaction.attribute10
, l_movement_transaction.attribute11
, l_movement_transaction.attribute12
, l_movement_transaction.attribute13
, l_movement_transaction.attribute14
, l_movement_transaction.attribute15
, l_movement_transaction.triangulation_country_eu_code
, l_movement_transaction.distribution_line_number
, l_movement_transaction.ship_to_name
, l_movement_transaction.ship_to_number
, l_movement_transaction.ship_to_site
, l_movement_transaction.edi_transaction_date
, l_movement_transaction.edi_transaction_reference
, l_movement_transaction.esl_drop_shipment_code;
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
(p_movement_statistics => l_movement_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);
INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
(p_movement_statistics => l_movement_transaction
, x_return_status => l_return_status
, x_msg_count => x_msg_count
, x_msg_data => x_msg_data
);