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

Line 1971: -- 3. clear msc_sr_source_org

1967: EXCEPTION WHEN others THEN
1968: g_ErrorCode := 'ERROR_INSERT_msc_int_source2_001022';
1969: raise;
1970: END;
1971: -- 3. clear msc_sr_source_org
1972: g_ErrorCode := '';
1973: BEGIN
1974: DELETE from MSC_SR_SOURCE_ORG
1975: WHERE

Line 1974: DELETE from MSC_SR_SOURCE_ORG

1970: END;
1971: -- 3. clear msc_sr_source_org
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

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 2140: -- 10. INSERT into MSC_SR_SOURCE_ORG

2136: EXCEPTION WHEN others THEN
2137: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2138: raise;
2139: END;
2140: -- 10. INSERT into MSC_SR_SOURCE_ORG
2141: BEGIN
2142: INSERT into MSC_SR_SOURCE_ORG (
2143: SR_SOURCE_ID,
2144: SR_SR_SOURCE_ID,

Line 2142: INSERT into MSC_SR_SOURCE_ORG (

2138: raise;
2139: END;
2140: -- 10. INSERT into MSC_SR_SOURCE_ORG
2141: BEGIN
2142: INSERT into MSC_SR_SOURCE_ORG (
2143: SR_SOURCE_ID,
2144: SR_SR_SOURCE_ID,
2145: SR_RECEIPT_ID,
2146: SOURCE_PARTNER_ID,

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