DBA Data[Home] [Help]

APPS.CSD_SPLIT_PKG dependencies on CS_STD

Line 857: and msiv.inventory_item_id = cptv.inventory_item_id and msiv.organization_id = cs_std.get_item_valdn_orgzn_id;

853: SELECT cptv.action_type, cptv.interface_to_om_flag, cptv.repair_quantity, cptv.quantity_in_wip, cptv.quantity_rcvd, cptv.status,
854: cptv.serial_number_control_code, crtv.repair_type_ref, msiv.comms_nl_trackable_flag, crtv.repair_mode
855: FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv
856: WHERE repair_line_id = p_repair_line_id and crtv.repair_type_id = cptv.repair_type_id and action_type = 'RMA'
857: and msiv.inventory_item_id = cptv.inventory_item_id and msiv.organization_id = cs_std.get_item_valdn_orgzn_id;
858:
859:
860: CURSOR c_ship_product_txn_line_info(p_repair_line_id IN NUMBER) IS
861: SELECT interface_to_om_flag