DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CS_STD

Line 2617: AND MSI.organization_id = cs_std.get_item_valdn_orgzn_id;

2613: SELECT primary_uom_code
2614: FROM mtl_system_items MSI, cs_estimate_details ced
2615: WHERE CED.estimate_detail_id = p_estimate_detail_id
2616: AND MSI.inventory_item_id = CED.inventory_item_id
2617: AND MSI.organization_id = cs_std.get_item_valdn_orgzn_id;
2618:
2619: -- Cursor to get the estimate line category for a given estimate line id
2620: CURSOR cur_getBillCategoryType (p_estimate_detail_id number)
2621: IS

Line 3660: -- and inv_master_organization_id = cs_std.get_item_valdn_orgzn_id;

3656: from csi_item_instances
3657: where inventory_item_id = v_inventory_item_id(j)
3658: and serial_number = v_Source_Serial_Number(j) ;
3659: -- Following statement is incorrect and not required so commenting it.
3660: -- and inv_master_organization_id = cs_std.get_item_valdn_orgzn_id;
3661: ---??????? 3742767
3662: Exception
3663: When No_Data_Found Then
3664: V_Source_Instance_Id(j) := V_Customer_Product_id(j);

Line 3745: and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;

3741: Into v_Non_Source_Serial_Number(j)
3742: from csi_item_instances
3743: where inventory_item_id = v_inventory_item_id(j)
3744: and instance_id = v_Customer_Product_Id(j)
3745: and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;
3746:
3747: v_Non_Source_instance_id(j) := v_Customer_Product_Id(j) ;
3748: Exception
3749: When No_Data_Found Then

Line 3804: -- and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;

3800: Into v_Non_Source_Serial_Number(j)
3801: from csi_item_instances
3802: where inventory_item_id = v_inventory_item_id(j)
3803: and instance_id = v_Customer_Product_Id(j);
3804: -- and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;
3805: -- Commented above line 3742767
3806: v_Non_Source_instance_id(j) := v_Customer_Product_Id(j) ;
3807: Exception
3808: When No_Data_Found Then