DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on GMI_ITEM_CONV_AUDIT_DETAILS

Line 1682: CURSOR c_gmi_item_conv_audit_details

1678: SELECT *
1679: FROM gmi_item_conv_audit
1680: WHERE conversion_id = pconversion_id;
1681:
1682: CURSOR c_gmi_item_conv_audit_details
1683: (pconv_audit_id NUMBER) IS
1684: SELECT *
1685: FROM gmi_item_conv_audit_details
1686: WHERE conv_audit_id = pconv_audit_id;

Line 1685: FROM gmi_item_conv_audit_details

1681:
1682: CURSOR c_gmi_item_conv_audit_details
1683: (pconv_audit_id NUMBER) IS
1684: SELECT *
1685: FROM gmi_item_conv_audit_details
1686: WHERE conv_audit_id = pconv_audit_id;
1687: BEGIN
1688: x_failure_count := 0;
1689: l_migrate_count := 0;

Line 1880: FOR adetail in c_gmi_item_conv_audit_details (cuadit.conv_audit_id) LOOP

1876: cuadit.creation_date,
1877: cuadit.last_updated_by,
1878: cuadit.last_update_date);
1879:
1880: FOR adetail in c_gmi_item_conv_audit_details (cuadit.conv_audit_id) LOOP
1881:
1882: -- Get the organization / subinventory for the warehouse
1883: l_field_name := 'Organization/ Subinventory';
1884: l_field_value := 'Warehouse = '||adetail.whse_code;