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_SRC_RECOMMEND_DETAIL

Line 1948: SELECT msc_int_src_recommend_detail.item_code,

1944: BEGIN
1945: -- 1. SourceItem
1946:
1947: INSERT into msc_int_source1 ( item_code, branch_code )
1948: SELECT msc_int_src_recommend_detail.item_code,
1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';
1952: EXCEPTION WHEN others THEN

Line 1949: msc_int_src_recommend_detail.destination_code

1945: -- 1. SourceItem
1946:
1947: INSERT into msc_int_source1 ( item_code, branch_code )
1948: SELECT msc_int_src_recommend_detail.item_code,
1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';
1952: EXCEPTION WHEN others THEN
1953: g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021';

Line 1950: FROM msc_int_src_recommend_detail

1946:
1947: INSERT into msc_int_source1 ( item_code, branch_code )
1948: SELECT msc_int_src_recommend_detail.item_code,
1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';
1952: EXCEPTION WHEN others THEN
1953: g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021';
1954: raise;

Line 1951: WHERE msc_int_src_recommend_detail.available = 'Yes';

1947: INSERT into msc_int_source1 ( item_code, branch_code )
1948: SELECT msc_int_src_recommend_detail.item_code,
1949: msc_int_src_recommend_detail.destination_code
1950: FROM msc_int_src_recommend_detail
1951: WHERE msc_int_src_recommend_detail.available = 'Yes';
1952: EXCEPTION WHEN others THEN
1953: g_ErrorCode := 'ERROR_INSERT_msc_int_source1_001021';
1954: raise;
1955: END;

Line 1961: SELECT msc_int_src_recommend_detail.item_code,

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')
1965: FROM msc_int_src_recommend_detail

Line 1962: msc_int_src_recommend_detail.destination_code,

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')
1965: FROM msc_int_src_recommend_detail
1966: WHERE msc_int_src_recommend_detail.available = 'Yes';

Line 1963: TO_DATE(msc_int_src_recommend_detail.start_date, 'YYYY-MM-DD'),

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')
1965: FROM msc_int_src_recommend_detail
1966: WHERE msc_int_src_recommend_detail.available = 'Yes';
1967: EXCEPTION WHEN others THEN

Line 1964: TO_DATE(msc_int_src_recommend_detail.end_date, 'YYYY-MM-DD')

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')
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';

Line 1965: FROM msc_int_src_recommend_detail

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')
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;

Line 1966: WHERE msc_int_src_recommend_detail.available = 'Yes';

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')
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;

Line 1981: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001001';

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
1981: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001001';
1982: raise;
1983: END;
1984: -- 4. clear msc_sr_receipt_org
1985: BEGIN

Line 1992: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001002';

1988: MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID in
1989: ( select MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID from MSC_SR_ASSIGNMENTS
1990: where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar );
1991: EXCEPTION WHEN others THEN
1992: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001002';
1993: NULL;
1994: END;
1995: -- 5. clear msc_sourcing_rules
1996: BEGIN

Line 2003: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001003';

1999: MSC_SOURCING_RULES.SOURCING_RULE_ID in
2000: ( select MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID from MSC_SR_ASSIGNMENTS
2001: where MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar );
2002: EXCEPTION WHEN others THEN
2003: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001003';
2004: raise;
2005: END;
2006: -- 6. clear msc_sr_assignments
2007: BEGIN

Line 2012: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001004';

2008: DELETE from MSC_SR_ASSIGNMENTS
2009: WHERE
2010: MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar;
2011: EXCEPTION WHEN others THEN
2012: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001004';
2013: raise;
2014: END;
2015: -- 7. Insert into MSC_SR_ASSIGNMENTS
2016: BEGIN

Line 2049: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005';

2045: sysdate,
2046: '-1'
2047: FROM msc_int_source1;
2048: EXCEPTION WHEN others THEN
2049: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001005';
2050: raise;
2051: END;
2052: -- 8. INSERT into MSC_SOURCING_RULES
2053:

Line 2095: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001006';

2091: MSC_PLAN_ORGANIZATIONS.PLAN_ID = planIdVar and
2092: MSC_PLAN_ORGANIZATIONS.SR_INSTANCE_ID = MSC_SR_ASSIGNMENTS.SR_INSTANCE_ID and
2093: MSC_PLAN_ORGANIZATIONS.ORGANIZATION_ID = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID;
2094: EXCEPTION WHEN others THEN
2095: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001006';
2096: raise;
2097: END;
2098: -- 9. INSERT into MSC_SR_RECEIPT_ORG
2099: BEGIN

Line 2137: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';

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

Line 2164: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

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
2167: end,
2168: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2165: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

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
2167: end,
2168: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2169: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

Line 2168: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

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
2167: end,
2168: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2169: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2170: else NULL
2171: end,
2172: MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,

Line 2169: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

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
2167: end,
2168: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2169: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2170: else NULL
2171: end,
2172: MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2173: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2173: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2169: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2170: else NULL
2171: end,
2172: MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2173: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2174: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2175: else NULL
2176: end,
2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

Line 2174: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )

2170: else NULL
2171: end,
2172: MSC_SR_RECEIPT_ORG.SR_INSTANCE_ID,
2173: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2174: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2175: else NULL
2176: end,
2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

Line 2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'

2173: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2174: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2175: else NULL
2176: end,
2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2179: else NULL
2180: end,
2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'

Line 2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)

2174: then substr( MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code, ':', 1,1) + 1 )
2175: else NULL
2176: end,
2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2179: else NULL
2180: end,
2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code

Line 2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'

2177: case when not MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier'
2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2179: else NULL
2180: end,
2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,

Line 2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code

2178: then substr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,1,instr(MSC_INT_SRC_RECOMMEND_DETAIL.origin_code,':',1,1)-1)
2179: else NULL
2180: end,
2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1

Line 2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),

2180: end,
2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3

Line 2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,

2181: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal'
2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2189: else 1

Line 2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1

2182: then MSC_INT_SRC_RECOMMEND_DETAIL.transport_mode_code
2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2189: else 1
2190: end,

Line 2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2

2183: end,
2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2189: else 1
2190: end,
2191: sysdate,

Line 2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3

2184: NVL(MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_percent,100),
2185: MSC_INT_SRC_RECOMMEND_DETAIL.preference,
2186: case when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Internal' then 1
2187: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Manufactured' then 2
2188: when MSC_INT_SRC_RECOMMEND_DETAIL.sourcing_type = 'Supplier' then 3
2189: else 1
2190: end,
2191: sysdate,
2192: '-1',

Line 2195: FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL

2191: sysdate,
2192: '-1',
2193: sysdate,
2194: '-1'
2195: FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL
2196: WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2197: AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2198: AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code

Line 2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code

2195: FROM MSC_SR_ASSIGNMENTS, MSC_SR_RECEIPT_ORG, MSC_INT_SRC_RECOMMEND_DETAIL
2196: WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2197: AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2198: AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2203: EXCEPTION WHEN others THEN

Line 2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )

2196: WHERE MSC_SR_ASSIGNMENTS.ASSIGNMENT_SET_ID = assignmentSetOutIdVar
2197: AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2198: AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2203: EXCEPTION WHEN others THEN
2204: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';

Line 2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)

2197: AND MSC_SR_ASSIGNMENTS.SOURCING_RULE_ID = MSC_SR_RECEIPT_ORG.SOURCING_RULE_ID
2198: AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2203: EXCEPTION WHEN others THEN
2204: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2205: raise;

Line 2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';

2198: AND MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_SR_ASSIGNMENTS.ORGANIZATION_ID
2199: AND MSC_SR_RECEIPT_ORG.RECEIPT_ORG_INSTANCE_ID || ':' || MSC_SR_RECEIPT_ORG.SR_RECEIPT_ORG = MSC_INT_SRC_RECOMMEND_DETAIL.destination_code
2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2203: EXCEPTION WHEN others THEN
2204: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2205: raise;
2206: END;

Line 2204: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';

2200: AND MSC_SR_RECEIPT_ORG.EFFECTIVE_DATE = TO_DATE( MSC_INT_SRC_RECOMMEND_DETAIL.start_date, 'YYYY-MM-DD' )
2201: AND MSC_SR_ASSIGNMENTS.INVENTORY_ITEM_ID = substr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,instr(MSC_INT_SRC_RECOMMEND_DETAIL.item_code,':',1)+1)
2202: AND MSC_INT_SRC_RECOMMEND_DETAIL.available = 'Yes';
2203: EXCEPTION WHEN others THEN
2204: g_ErrorCode := 'ERROR_UPDATE_MSC_INT_SRC_RECOMMEND_DETAIL_001007';
2205: raise;
2206: END;
2207: Status := 'SUCCESS';
2208: