APPS.CSD_SPLIT_PKG dependencies on CSD_PRODUCT_TXNS_V

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

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

Line 860: FROM csd_product_txns_v

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

Line 1073: FROM csd_product_txns_v

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