DBA Data[Home] [Help]

APPS.INVPPRCI dependencies on MTL_PARAMETERS

Line 496: MTL_PARAMETERS MP1,

492: prg_appid,
493: prg_id,
494: SYSDATE
495: from
496: MTL_PARAMETERS MP1,
497: MTL_PARAMETERS MP2,
498: MTL_SYSTEM_ITEMS_B M, /* Model */
499: MTL_SYSTEM_ITEMS_INTERFACE I
500: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 497: MTL_PARAMETERS MP2,

493: prg_id,
494: SYSDATE
495: from
496: MTL_PARAMETERS MP1,
497: MTL_PARAMETERS MP2,
498: MTL_SYSTEM_ITEMS_B M, /* Model */
499: MTL_SYSTEM_ITEMS_INTERFACE I
500: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID
501: and I.COPY_ITEM_ID = M.INVENTORY_ITEM_ID

Line 534: MTL_PARAMETERS MP1,

530: NVL(I.CREATION_DATE,SYSDATE),
531: user_id, /* created_by */
532: login_id /* last_update_login */
533: from
534: MTL_PARAMETERS MP1,
535: MTL_PARAMETERS MP2,
536: MTL_SYSTEM_ITEMS_B M, /* Model */
537: MTL_SYSTEM_ITEMS_INTERFACE I
538: , FND_LANGUAGES L

Line 535: MTL_PARAMETERS MP2,

531: user_id, /* created_by */
532: login_id /* last_update_login */
533: from
534: MTL_PARAMETERS MP1,
535: MTL_PARAMETERS MP2,
536: MTL_SYSTEM_ITEMS_B M, /* Model */
537: MTL_SYSTEM_ITEMS_INTERFACE I
538: , FND_LANGUAGES L
539: where M.ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 581: MTL_PARAMETERS MP1,

577: login_id, /* last_update_login */
578: SYSDATE,
579: SYSDATE
580: from
581: MTL_PARAMETERS MP1,
582: MTL_PARAMETERS MP2,
583: MTL_SYSTEM_ITEMS_INTERFACE R
584: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
585: and MP2.organization_id = R.organization_id

Line 582: MTL_PARAMETERS MP2,

578: SYSDATE,
579: SYSDATE
580: from
581: MTL_PARAMETERS MP1,
582: MTL_PARAMETERS MP2,
583: MTL_SYSTEM_ITEMS_INTERFACE R
584: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
585: and MP2.organization_id = R.organization_id
586: and ((R.ORGANIZATION_ID = MP1.ORGANIZATION_ID) OR

Line 624: MTL_PARAMETERS MP1,

620: prg_id,
621: SYSDATE,
622: req_id
623: from MTL_SYSTEM_ITEMS_B SI,
624: MTL_PARAMETERS MP1,
625: MTL_PARAMETERS MP2,
626: MTL_SYSTEM_ITEMS_INTERFACE R
627: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
628: and R.inventory_item_id = SI.inventory_item_id

Line 625: MTL_PARAMETERS MP2,

621: SYSDATE,
622: req_id
623: from MTL_SYSTEM_ITEMS_B SI,
624: MTL_PARAMETERS MP1,
625: MTL_PARAMETERS MP2,
626: MTL_SYSTEM_ITEMS_INTERFACE R
627: where R.set_id = TO_CHAR(to_number(USERENV('SESSIONID')))
628: and R.inventory_item_id = SI.inventory_item_id
629: and R.organization_id = SI.organization_id

Line 767: MTL_PARAMETERS MP1,

763: prg_id, /* program_id */
764: SYSDATE
765: from
766: CST_ITEM_COSTS C,
767: MTL_PARAMETERS MP1,
768: MTL_PARAMETERS MP2,
769: MTL_SYSTEM_ITEMS_INTERFACE SI
770: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
771: and C.INVENTORY_ITEM_ID = SI.Copy_item_id

Line 768: MTL_PARAMETERS MP2,

764: SYSDATE
765: from
766: CST_ITEM_COSTS C,
767: MTL_PARAMETERS MP1,
768: MTL_PARAMETERS MP2,
769: MTL_SYSTEM_ITEMS_INTERFACE SI
770: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
771: and C.INVENTORY_ITEM_ID = SI.Copy_item_id
772: and C.COST_TYPE_ID IN ( MP1.PRIMARY_COST_METHOD, MP1.AVG_RATES_COST_TYPE_ID)

Line 881: MTL_PARAMETERS MP1,

877: C.ATTRIBUTE14,
878: C.ATTRIBUTE15
879: from
880: CST_ITEM_COST_DETAILS C,
881: MTL_PARAMETERS MP1,
882: MTL_PARAMETERS MP2,
883: MTL_SYSTEM_ITEMS_INTERFACE SI
884: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
885: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID

Line 882: MTL_PARAMETERS MP2,

878: C.ATTRIBUTE15
879: from
880: CST_ITEM_COST_DETAILS C,
881: MTL_PARAMETERS MP1,
882: MTL_PARAMETERS MP2,
883: MTL_SYSTEM_ITEMS_INTERFACE SI
884: where C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
885: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID
886: and C.COST_TYPE_ID IN ( MP1.PRIMARY_COST_METHOD, MP1.AVG_RATES_COST_TYPE_ID)

Line 986: MTL_PARAMETERS MP1,

982: 0,
983: -1 /* txn_id */
984: from
985: MTL_SYSTEM_ITEMS_INTERFACE SI,
986: MTL_PARAMETERS MP1,
987: MTL_PARAMETERS MP2,
988: CST_ITEM_COSTS C
989: where
990: C.ORGANIZATION_ID = MP1.ORGANIZATION_ID

Line 987: MTL_PARAMETERS MP2,

983: -1 /* txn_id */
984: from
985: MTL_SYSTEM_ITEMS_INTERFACE SI,
986: MTL_PARAMETERS MP1,
987: MTL_PARAMETERS MP2,
988: CST_ITEM_COSTS C
989: where
990: C.ORGANIZATION_ID = MP1.ORGANIZATION_ID
991: and C.INVENTORY_ITEM_ID = SI.COPY_ITEM_ID

Line 1076: from MTL_PARAMETERS MP1,

1072: prg_appid, /* program_application_id */
1073: prg_id, /* program_id */
1074: SYSDATE, /* program_update_date */
1075: MP1.organization_id
1076: from MTL_PARAMETERS MP1,
1077: MTL_PARAMETERS MP2,
1078: mtl_item_categories_interface ici,
1079: mtl_system_items_interface si
1080: where si.inventory_item_id = ici.inventory_item_id

Line 1077: MTL_PARAMETERS MP2,

1073: prg_id, /* program_id */
1074: SYSDATE, /* program_update_date */
1075: MP1.organization_id
1076: from MTL_PARAMETERS MP1,
1077: MTL_PARAMETERS MP2,
1078: mtl_item_categories_interface ici,
1079: mtl_system_items_interface si
1080: where si.inventory_item_id = ici.inventory_item_id
1081: and si.organization_id = ici.organization_id

Line 1121: MTL_PARAMETERS MP1,

1117: SYSDATE, /* program_update_date */
1118: MP1.organization_id
1119: from
1120: mtl_item_categories ic,
1121: MTL_PARAMETERS MP1,
1122: MTL_PARAMETERS MP2,
1123: mtl_system_items_interface si
1124: where si.copy_item_id = ic.inventory_item_id
1125: and si.organization_id = ic.organization_id

Line 1122: MTL_PARAMETERS MP2,

1118: MP1.organization_id
1119: from
1120: mtl_item_categories ic,
1121: MTL_PARAMETERS MP1,
1122: MTL_PARAMETERS MP2,
1123: mtl_system_items_interface si
1124: where si.copy_item_id = ic.inventory_item_id
1125: and si.organization_id = ic.organization_id
1126: and MP2.organization_id = si.organization_id