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_INT_SOURCE2

Line 1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2

1926: ) AS
1927: g_ErrorCode VARCHAR2(1000);
1928: BEGIN
1929: /* implementation starts here */
1930: -- 1. and 2. drop, create, populate 2 temp tables msc_int_source1, msc_int_source2
1931: BEGIN
1932: DELETE FROM msc_int_source1; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1933: EXCEPTION WHEN others THEN
1934: g_ErrorCode := 'ERROR_DELETE_msc_int_source1_001011';

Line 1939: DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;

1935: raise;
1936: END;
1937:
1938: BEGIN
1939: DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1940: EXCEPTION WHEN others THEN
1941: g_ErrorCode := 'ERROR_DELETE_msc_int_source2_001012';
1942: raise;
1943: END;

Line 1941: g_ErrorCode := 'ERROR_DELETE_msc_int_source2_001012';

1937:
1938: BEGIN
1939: DELETE FROM msc_int_source2; -- where msc_int_ascp_prodcost_kpi.plan_id=PlanIdVar;
1940: EXCEPTION WHEN others THEN
1941: g_ErrorCode := 'ERROR_DELETE_msc_int_source2_001012';
1942: raise;
1943: END;
1944: BEGIN
1945: -- 1. SourceItem

Line 1960: INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )

1956:
1957: BEGIN
1958: -- 2. SourceItemBranch
1959:
1960: INSERT into msc_int_source2 ( item_code, branch_code, enable_date, disable_date )
1961: SELECT msc_int_src_recommend_detail.item_code,
1962: msc_int_src_recommend_detail.destination_code,
1963: TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),
1964: TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')

Line 1968: g_ErrorCode := 'ERROR_INSERT_msc_int_source2_001022';

1964: TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')
1965: FROM msc_int_src_recommend_detail
1966: WHERE msc_int_src_recommend_detail.available = 'Yes';
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 := '';

Line 2115: ) -- // msc_int_source2 == source

2111: LAST_UPDATE_DATE,
2112: LAST_UPDATED_BY,
2113: CREATION_DATE,
2114: CREATED_BY
2115: ) -- // msc_int_source2 == source
2116: SELECT
2117: MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2118: -1 * MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2119: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // I suspect I am supposed to put something here but I don't know what.

Line 2119: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // I suspect I am supposed to put something here but I don't know what.

2115: ) -- // msc_int_source2 == source
2116: SELECT
2117: MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2118: -1 * MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2119: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // I suspect I am supposed to put something here but I don't know what.
2120: substr(msc_int_source2.branch_code,instr(msc_int_source2.branch_code,':',1,1)+1),
2121: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // Eventually this should be obtained from the branch code.
2122: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2123: NULL, -- This is empty until we get customer sourcing

Line 2120: substr(msc_int_source2.branch_code,instr(msc_int_source2.branch_code,':',1,1)+1),

2116: SELECT
2117: MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2118: -1 * MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2119: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // I suspect I am supposed to put something here but I don't know what.
2120: substr(msc_int_source2.branch_code,instr(msc_int_source2.branch_code,':',1,1)+1),
2121: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // Eventually this should be obtained from the branch code.
2122: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2123: NULL, -- This is empty until we get customer sourcing
2124: NULL, -- This is empty until we get customer sourcing

Line 2121: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // Eventually this should be obtained from the branch code.

2117: MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2118: -1 * MSC_SR_RECEIPT_ORG_S.NEXTVAL,
2119: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // I suspect I am supposed to put something here but I don't know what.
2120: substr(msc_int_source2.branch_code,instr(msc_int_source2.branch_code,':',1,1)+1),
2121: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // Eventually this should be obtained from the branch code.
2122: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2123: NULL, -- This is empty until we get customer sourcing
2124: NULL, -- This is empty until we get customer sourcing
2125: msc_int_source2.enable_date,

Line 2125: msc_int_source2.enable_date,

2121: substr(msc_int_source2.branch_code,1,instr(msc_int_source2.branch_code,':',1,1)-1), -- // Eventually this should be obtained from the branch code.
2122: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2123: NULL, -- This is empty until we get customer sourcing
2124: NULL, -- This is empty until we get customer sourcing
2125: msc_int_source2.enable_date,
2126: msc_int_source2.disable_date,
2127: sysdate,
2128: '-1',
2129: sysdate,

Line 2126: msc_int_source2.disable_date,

2122: MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID,
2123: NULL, -- This is empty until we get customer sourcing
2124: NULL, -- This is empty until we get customer sourcing
2125: msc_int_source2.enable_date,
2126: msc_int_source2.disable_date,
2127: sysdate,
2128: '-1',
2129: sysdate,
2130: '-1'

Line 2131: FROM MSC_SR_ASSIGNMENTS, msc_int_source2

2127: sysdate,
2128: '-1',
2129: sysdate,
2130: '-1'
2131: FROM MSC_SR_ASSIGNMENTS, msc_int_source2
2132: WHERE
2133: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2134: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = msc_int_source2.item_code and
2135: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.ORGANIZATION_ID = msc_int_source2.branch_code;

Line 2134: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = msc_int_source2.item_code and

2130: '-1'
2131: FROM MSC_SR_ASSIGNMENTS, msc_int_source2
2132: WHERE
2133: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2134: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = msc_int_source2.item_code and
2135: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.ORGANIZATION_ID = msc_int_source2.branch_code;
2136: EXCEPTION WHEN others THEN
2137: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2138: raise;

Line 2135: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.ORGANIZATION_ID = msc_int_source2.branch_code;

2131: FROM MSC_SR_ASSIGNMENTS, msc_int_source2
2132: WHERE
2133: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar and
2134: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = msc_int_source2.item_code and
2135: MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID || ':' || MSC_SR_ASSIGNMENTS.ORGANIZATION_ID = msc_int_source2.branch_code;
2136: EXCEPTION WHEN others THEN
2137: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2138: raise;
2139: END;