APPS.CSD_SPLIT_PKG dependencies on CSD_PRODUCT_TXNS_V

Line 855: FROM csd_product_txns_v cptv, csd_repair_types_vl crtv, mtl_system_items_vl msiv

851:
852: CURSOR c_rma_product_txn_line_info(p_repair_line_id IN NUMBER) IS
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:

Line 862: FROM csd_product_txns_v

858:
859:
860: CURSOR c_ship_product_txn_line_info(p_repair_line_id IN NUMBER) IS
861: SELECT interface_to_om_flag
862: FROM csd_product_txns_v
863: WHERE repair_line_id = p_repair_line_id and action_type = 'SHIP';
864:
865: CURSOR c_repair_type_ref(p_repair_line_id IN NUMBER) IS
866: SELECT crtv.repair_type_ref

Line 1075: FROM csd_product_txns_v

1071: x_ship_prod_txn_tbl CSD_PROCESS_PVT.PRODUCT_TXN_TBL;
1072:
1073: CURSOR c_rma_product_txns_id(p_original_repair_line_id IN NUMBER) IS
1074: SELECT product_transaction_id
1075: FROM csd_product_txns_v
1076: WHERE repair_line_id = p_original_repair_line_id and ACTION_TYPE = 'RMA';
1077:
1078: l_debug_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1079: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;