APPS.CSD_REPAIRS_PVT dependencies on CSD_FLOW_STATUSES_B

Line 124: FROM CSD_FLOW_STATUSES_B FS_B,

120: SELECT FS_B.flow_status_id,
121: FS_B.flow_status_code,
122: FS_LKUP.meaning flow_status,
123: FS_B.status_code
124: FROM CSD_FLOW_STATUSES_B FS_B,
125: FND_LOOKUPS FS_LKUP
126: WHERE FS_B.flow_status_code = 'D' AND
127: FS_LKUP.lookup_type = 'CSD_REPAIR_FLOW_STATUS' AND
128: FS_LKUP.lookup_code = FS_B.flow_status_code AND

Line 4119: FROM CSD_FLOW_STATUSES_B

4115:
4116: -- Get state, state is the status_code in the scehma. status is flow_status
4117: CURSOR flow_stat_cur(p_repair_status_id VARCHAR2) IS
4118: SELECT STATUS_CODE
4119: FROM CSD_FLOW_STATUSES_B
4120: WHERE FLOW_STATUS_ID = p_repair_status_id;
4121:
4122:
4123: BEGIN

Line 4362: CSD_FLOW_STATUSES_B TO_FS_B,

4358: TO_FS_B.status_code,
4359: TO_FS_B.flow_status_code to_flow_status_code,
4360: FROM_FS_B.flow_status_code from_flow_status_code
4361: FROM CSD_FLWSTS_TRANS_B FS_TRANS,
4362: CSD_FLOW_STATUSES_B TO_FS_B,
4363: CSD_FLOW_STATUSES_B FROM_FS_B
4364: WHERE FS_TRANS.from_flow_status_id = p_from_flow_status_id AND
4365: FS_TRANS.to_flow_status_id = p_to_flow_status_id AND
4366: FS_TRANS.repair_type_id = p_repair_type_id AND

Line 4363: CSD_FLOW_STATUSES_B FROM_FS_B

4359: TO_FS_B.flow_status_code to_flow_status_code,
4360: FROM_FS_B.flow_status_code from_flow_status_code
4361: FROM CSD_FLWSTS_TRANS_B FS_TRANS,
4362: CSD_FLOW_STATUSES_B TO_FS_B,
4363: CSD_FLOW_STATUSES_B FROM_FS_B
4364: WHERE FS_TRANS.from_flow_status_id = p_from_flow_status_id AND
4365: FS_TRANS.to_flow_status_id = p_to_flow_status_id AND
4366: FS_TRANS.repair_type_id = p_repair_type_id AND
4367: TO_FS_B.flow_status_id = FS_TRANS.to_flow_status_id AND