VIEW: APPS.GMP_RSRC_UNAVAIL_DTL_V

Source

View Text - Preformatted

SELECT h.exception_id, h.exception_code, a.resource_id, a.instance_id, a.resource_units, d.from_date, d.TO_DATE, TO_NUMBER(NULL) wip_entity_id, TO_NUMBER(NULL) op_seq, TO_NUMBER(NULL) maint_org_id, d.reason_code, mtr.description FROM gmp_rsrc_excp_asnmt a, gmp_rsrc_excp_dtl d, gmp_rsrc_excp_hdr h, MTL_TRANSACTION_REASONS mtr WHERE h.exception_id = d.exception_id AND d.exception_id = a.exception_id AND mtr.reason_name = d.reason_code AND h.inactive_ind = 0 UNION SELECT 0, NULL, gru.resource_id, gru.instance_id, gru.resource_units, gru.from_date, gru.TO_DATE, gru.wip_entity_id, gru.op_seq, gru.maint_org_id, gru.REASON_CODE, mtr.description FROM gmp_rsrc_unavail_man gru, MTL_TRANSACTION_REASONS mtr WHERE mtr.reason_name = gru.reason_code

View Text - HTML Formatted

SELECT H.EXCEPTION_ID
, H.EXCEPTION_CODE
, A.RESOURCE_ID
, A.INSTANCE_ID
, A.RESOURCE_UNITS
, D.FROM_DATE
, D.TO_DATE
, TO_NUMBER(NULL) WIP_ENTITY_ID
, TO_NUMBER(NULL) OP_SEQ
, TO_NUMBER(NULL) MAINT_ORG_ID
, D.REASON_CODE
, MTR.DESCRIPTION
FROM GMP_RSRC_EXCP_ASNMT A
, GMP_RSRC_EXCP_DTL D
, GMP_RSRC_EXCP_HDR H
, MTL_TRANSACTION_REASONS MTR
WHERE H.EXCEPTION_ID = D.EXCEPTION_ID
AND D.EXCEPTION_ID = A.EXCEPTION_ID
AND MTR.REASON_NAME = D.REASON_CODE
AND H.INACTIVE_IND = 0 UNION SELECT 0
, NULL
, GRU.RESOURCE_ID
, GRU.INSTANCE_ID
, GRU.RESOURCE_UNITS
, GRU.FROM_DATE
, GRU.TO_DATE
, GRU.WIP_ENTITY_ID
, GRU.OP_SEQ
, GRU.MAINT_ORG_ID
, GRU.REASON_CODE
, MTR.DESCRIPTION
FROM GMP_RSRC_UNAVAIL_MAN GRU
, MTL_TRANSACTION_REASONS MTR
WHERE MTR.REASON_NAME = GRU.REASON_CODE