APPS.MSC_ATP_PROC dependencies on MSC_TP_SITE_ID_LID

Line 371: FROM msc_tp_site_id_lid tpsite

367: END IF;
368:
369: SELECT TP_SITE_ID
370: INTO l_ship_to_site_id
371: FROM msc_tp_site_id_lid tpsite
372: WHERE tpsite.SR_TP_SITE_ID = p_customer_site_id
373: AND tpsite.SR_INSTANCE_ID = p_instance_id
374: AND tpsite.PARTNER_TYPE = 2;
375: IF PG_DEBUG in ('Y', 'C') THEN

Line 3546: FROM msc_tp_site_id_lid mtsil,

3542:
3543: SELECT mtsil.sr_tp_site_id, mtps.tp_site_code
3544: INTO l_other_cols.sr_supplier_site_id(j),
3545: l_other_cols.vendor_site_name(j)
3546: FROM msc_tp_site_id_lid mtsil,
3547: msc_trading_partner_sites mtps
3548: WHERE mtsil.tp_site_id = mtps.partner_site_id
3549: AND mtsil.sr_instance_id = l_sources.instance_id(j)
3550: AND mtsil.partner_type = 1

Line 5571: MSC_TP_SITE_ID_LID MTSIL

5567: MSC_SR_SOURCE_ORG SOURCE_ORG,
5568: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5569: MSC_SOURCING_RULES MSR,
5570: MSC_SR_ASSIGNMENTS MSRA,
5571: MSC_TP_SITE_ID_LID MTSIL
5572: WHERE
5573: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
5574: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5575: AND MSRA.PARTNER_ID IS NOT NULL

Line 5778: MSC_TP_SITE_ID_LID MTSIL

5774: MSC_SR_SOURCE_ORG SOURCE_ORG,
5775: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5776: MSC_SOURCING_RULES MSR,
5777: MSC_SR_ASSIGNMENTS MSRA,
5778: MSC_TP_SITE_ID_LID MTSIL
5779: WHERE
5780: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
5781: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
5782: AND MSRA.PARTNER_ID IS NOT NULL

Line 5861: -- MSC_TP_SITE_ID_LID MTSIL,

5857: MSC_SR_SOURCE_ORG SOURCE_ORG,
5858: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5859: MSC_SOURCING_RULES MSR,
5860: -- MSC_TRADING_PARTNER_SITES TP,
5861: -- MSC_TP_SITE_ID_LID MTSIL,
5862: MSC_SR_ASSIGNMENTS MSRA
5863: WHERE
5864: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */
5865: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6068: -- MSC_TP_SITE_ID_LID MTSIL

6064: MSC_SR_SOURCE_ORG SOURCE_ORG,
6065: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6066: MSC_SOURCING_RULES MSR,
6067: MSC_SR_ASSIGNMENTS MSRA
6068: -- MSC_TP_SITE_ID_LID MTSIL
6069: WHERE
6070: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */
6071: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6072: AND MSRA.CATEGORY_NAME = CAT.CATEGORY_NAME

Line 6150: MSC_TP_SITE_ID_LID MTSIL

6146: MSC_SR_SOURCE_ORG SOURCE_ORG,
6147: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6148: MSC_SOURCING_RULES MSR,
6149: MSC_SR_ASSIGNMENTS MSRA,
6150: MSC_TP_SITE_ID_LID MTSIL
6151: WHERE
6152: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
6153: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6154: AND MSRA.PARTNER_ID IS NOT NULL

Line 6354: -- MSC_TP_SITE_ID_LID MTSIL

6350: MSC_SR_SOURCE_ORG SOURCE_ORG,
6351: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6352: MSC_SOURCING_RULES MSR,
6353: MSC_SR_ASSIGNMENTS MSRA
6354: -- MSC_TP_SITE_ID_LID MTSIL
6355: WHERE
6356: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
6357: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id
6358: AND MSRA.SOURCING_RULE_ID = MSR.SOURCING_RULE_ID

Line 6444: MSC_TP_SITE_ID_LID MTSIL,

6440: MSC_SR_SOURCE_ORG SOURCE_ORG,
6441: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6442: MSC_SOURCING_RULES MSR,
6443: MSC_SR_ASSIGNMENTS MSRA,
6444: MSC_TP_SITE_ID_LID MTSIL,
6445: MSC_SHIP_SET_TEMP MSST
6446: WHERE
6447: MSRA.ASSIGNMENT_TYPE = 6 /* ITEM-ORG */
6448: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6793: MSC_TP_SITE_ID_LID MTSIL,

6789: MSC_SR_SOURCE_ORG SOURCE_ORG,
6790: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6791: MSC_SOURCING_RULES MSR,
6792: MSC_SR_ASSIGNMENTS MSRA,
6793: MSC_TP_SITE_ID_LID MTSIL,
6794: MSC_SHIP_SET_TEMP MSST
6795: WHERE
6796: MSRA.ASSIGNMENT_TYPE = 5 /* CATEGORY-ORG */
6797: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 6937: -- MSC_TP_SITE_ID_LID MTSIL,

6933: MSC_SR_SOURCE_ORG SOURCE_ORG,
6934: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6935: MSC_SOURCING_RULES MSR,
6936: MSC_SR_ASSIGNMENTS MSRA,
6937: -- MSC_TP_SITE_ID_LID MTSIL,
6938: MSC_SHIP_SET_TEMP MSST
6939: WHERE
6940:
6941: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */

Line 7269: -- MSC_TP_SITE_ID_LID MTSIL,

7265: MSC_SR_SOURCE_ORG SOURCE_ORG,
7266: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7267: MSC_SOURCING_RULES MSR,
7268: MSC_SR_ASSIGNMENTS MSRA,
7269: -- MSC_TP_SITE_ID_LID MTSIL,
7270: MSC_SHIP_SET_TEMP MSST
7271: WHERE
7272:
7273: MSRA.ASSIGNMENT_TYPE = 2 /* CATEGORY */

Line 7412: MSC_TP_SITE_ID_LID MTSIL,

7408: MSC_SR_SOURCE_ORG SOURCE_ORG,
7409: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7410: MSC_SOURCING_RULES MSR,
7411: MSC_SR_ASSIGNMENTS MSRA,
7412: MSC_TP_SITE_ID_LID MTSIL,
7413: MSC_SHIP_SET_TEMP MSST
7414: WHERE
7415: MSRA.ASSIGNMENT_TYPE = 4 /* ORG */
7416: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id

Line 7741: -- MSC_TP_SITE_ID_LID MTSIL,

7737: MSC_SR_SOURCE_ORG SOURCE_ORG,
7738: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7739: MSC_SOURCING_RULES MSR,
7740: MSC_SR_ASSIGNMENTS MSRA,
7741: -- MSC_TP_SITE_ID_LID MTSIL,
7742: MSC_SHIP_SET_TEMP MSST
7743: WHERE
7744: MSRA.ASSIGNMENT_TYPE = 1 /* GLOBAL */
7745: AND MSRA.ASSIGNMENT_SET_ID = p_assignment_set_id