eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_SR_SOURCE_ORG_S

Line 1976: MSC_SR_SOURCE_ORG.SR_RECEIPT_ID in

1972: g_ErrorCode := '';
1973: BEGIN
1974: DELETE from MSC_SR_SOURCE_ORG
1975: WHERE
1976: MSC_SR_SOURCE_ORG.SR_RECEIPT_ID in
1977: ( select MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID from MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG
1978: where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
1979: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID );
1980: EXCEPTION WHEN others THEN

Line 2161: MSC_SR_SOURCE_ORG_S.NEXTVAL,

2157: CREATION_DATE,
2158: CREATED_BY
2159: )
2160: SELECT
2161: MSC_SR_SOURCE_ORG_S.NEXTVAL,
2162: -1 * MSC_SR_SOURCE_ORG_S.NEXTVAL,
2163: MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID,
2164: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2165: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

Line 2162: -1 * MSC_SR_SOURCE_ORG_S.NEXTVAL,

2158: CREATED_BY
2159: )
2160: SELECT
2161: MSC_SR_SOURCE_ORG_S.NEXTVAL,
2162: -1 * MSC_SR_SOURCE_ORG_S.NEXTVAL,
2163: MSC_SR_RECEIPT_ORG.SR_RECEIPT_ID,
2164: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2165: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2166: else NULL