APPS.CSD_BULK_RECEIVE_UTIL dependencies on CS_STD

Line 504: and organization_id = cs_std.get_item_valdn_orgzn_id;

500: select serial_number_control_code,
501: comms_nl_trackable_flag
502: from mtl_system_items_kfv
503: where inventory_item_id = p_inventory_item_id
504: and organization_id = cs_std.get_item_valdn_orgzn_id;
505:
506: -- Cursor to derive the Instance and IB Owner
507: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
508: Select

Line 953: and organization_id = cs_std.get_item_valdn_orgzn_id;

949: comms_nl_trackable_flag,
950: revision_qty_control_code
951: from mtl_system_items_kfv
952: where inventory_item_id = p_inventory_item_id
953: and organization_id = cs_std.get_item_valdn_orgzn_id;
954:
955: -- Fix for bug#6082836
956: -- Added business_process_id
957: -- Cursor to derive repair type attribute

Line 993: and organization_id = cs_std.get_item_valdn_orgzn_id;

989: Cursor c_get_item_uom_code (p_inventory_item_id number) is
990: Select primary_uom_code
991: from mtl_system_items_kfv
992: where inventory_item_id = p_inventory_item_id
993: and organization_id = cs_std.get_item_valdn_orgzn_id;
994:
995: -- Fix for bug#6082836
996: -- Cursor to get sr details
997: Cursor c_get_sr_details (p_incident_id in number) is

Line 1822: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;

1818: and cib.incident_id = cr.incident_id
1819: and cpt.order_header_id = p_order_header_id
1820: and cpt.order_line_id = p_order_line_id
1821: and mtl.inventory_item_id = cpt.inventory_item_id
1822: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;
1823:
1824: Cursor c_get_org (p_order_header_id number) is
1825: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
1826: from oe_order_headers_all a,

Line 3535: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;

3531: and cib.incident_id = cr.incident_id
3532: and cpt.order_header_id = p_order_header_id
3533: and cpt.order_line_id = p_order_line_id
3534: and mtl.inventory_item_id = cpt.inventory_item_id
3535: and mtl.organization_id = cs_std.get_item_valdn_orgzn_id;
3536:
3537: Cursor c_get_org (p_order_header_id number) is
3538: Select nvl(b.ship_from_org_id,a.ship_from_org_id)
3539: from oe_order_headers_all a,