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.CSTPMECS dependencies on CST_LISTS

Line 71: FROM cst_lists CL,

67: AND rollup_source_type = 1 /* User Defined */
68: AND EXISTS
69: (
70: SELECT 'x'
71: FROM cst_lists CL,
72: cst_activity_costs CAC
73: WHERE CL.list_id = I_LIST_ID
74: AND CL.entity_id = CICD.inventory_item_id
75: AND CAC.organization_id = CICD.organization_id

Line 129: DELETE FROM cst_lists L

125:
126: /*===============================================================*/
127: /* Removed any item from the list where there is no PO receipt */
128: /*===============================================================*/
129: DELETE FROM cst_lists L
130: WHERE L.list_id = I_LIST_ID
131: AND NOT EXISTS (
132: SELECT 'X'
133: FROM mtl_material_transactions M

Line 223: FROM cst_lists L

219: AND rollup_source_type = 1 /* User Defined */
220: AND EXISTS
221: (
222: SELECT 'X'
223: FROM cst_lists L
224: WHERE L.list_id = I_LIST_ID
225: AND L.entity_id = CICD.inventory_item_id
226: )
227: ;

Line 274: DELETE FROM cst_lists L

270:
271: /*===============================================================*/
272: /* Removed any item from the list where there is no PO receipt */
273: /*===============================================================*/
274: DELETE FROM cst_lists L
275: WHERE L.list_id = I_LIST_ID
276: AND NOT EXISTS (
277: SELECT 'X'
278: FROM mtl_material_transactions M

Line 436: FROM cst_lists L

432:
433: AND EXISTS
434: (
435: SELECT 'X'
436: FROM cst_lists L
437: WHERE L.list_id = I_LIST_ID
438: AND L.entity_id = CICD.inventory_item_id
439: )
440: ;

Line 487: /* in cst_lists that have open POs associated with them. This data will be */

483: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
484:
485: /*=============================================================================*/
486: /* Populate the global temporary table cst_open_pos_temp with all of the items */
487: /* in cst_lists that have open POs associated with them. This data will be */
488: /* used below to update the item cost and usage rate in CICD. */
489: /*=============================================================================*/
490:
491: /* Bug 3589032 - Instead of inserting the open POs directly into the temp

Line 503: FROM cst_lists

499: inventory_item_id)
500: SELECT
501: NULL
502: , entity_id
503: FROM cst_lists
504: WHERE list_id = I_LIST_ID;
505:
506:
507: UPDATE cst_open_pos_temp COPT

Line 551: DELETE FROM cst_lists

547: /* Now delete all items from the temp tables where there were no OPEN POs found */
548: DELETE FROM cst_open_pos_temp
549: WHERE usage_rate_or_amount IS NULL;
550:
551: DELETE FROM cst_lists
552: WHERE list_id = I_LIST_ID
553: AND entity_id NOT IN (SELECT inventory_item_id FROM cst_open_pos_temp);
554:
555: /*===============================================================*/

Line 676: FROM CST_LISTS L

672: AND COST_TYPE_ID = I_COST_TYPE_ID
673: AND EXISTS
674: (
675: SELECT 'X'
676: FROM CST_LISTS L
677: WHERE L.LIST_ID = I_LIST_ID
678: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
679: )
680: ;

Line 699: FROM CST_LISTS L

695: AND COST_TYPE_ID = I_COST_TYPE_ID
696: AND EXISTS
697: (
698: SELECT 'X'
699: FROM CST_LISTS L
700: WHERE L.LIST_ID = I_LIST_ID
701: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
702: )
703: ;

Line 780: FROM CST_LISTS L

776: I_RESOURCE_ID)
777: AND A.INVENTORY_ITEM_ID IN
778: (
779: SELECT ENTITY_ID
780: FROM CST_LISTS L
781: WHERE LIST_ID = I_LIST_ID
782: )
783: ;
784:

Line 859: FROM CST_LISTS L

855: I_RESOURCE_ID)
856: AND EXISTS
857: (
858: SELECT 'X'
859: FROM CST_LISTS L
860: WHERE LIST_ID = I_LIST_ID
861: AND ENTITY_ID = A.INVENTORY_ITEM_ID
862: )
863: ;

Line 923: FROM CST_LISTS L

919: AND COST_TYPE_ID = I_COST_TYPE_ID
920: AND EXISTS
921: (
922: SELECT 'X'
923: FROM CST_LISTS L
924: WHERE L.LIST_ID = I_LIST_ID
925: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
926: )
927: ;

Line 956: FROM CST_LISTS L

952: AND COST_TYPE_ID = I_COST_TYPE_ID
953: AND EXISTS
954: (
955: SELECT 'X'
956: FROM CST_LISTS L
957: WHERE L.LIST_ID = I_LIST_ID
958: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
959: )
960: ;

Line 1016: DELETE FROM cst_lists L

1012: the above statement is redundant. After having done this
1013: the above statement is redundant
1014: +==============================================================*/
1015: /*
1016: DELETE FROM cst_lists L
1017: WHERE L.list_id = I_LIST_ID
1018: AND 0 >=
1019: (SELECT NVL(sum(quantity_invoiced * UCR.conversion_rate),0)
1020: FROM mtl_uom_conversions_view UCR

Line 1048: DELETE FROM cst_lists L

1044: Zero or negative item Costs.After having done this the above statement
1045: is redundant
1046: +==============================================================*/
1047:
1048: DELETE FROM cst_lists L
1049: WHERE L.list_id = I_LIST_ID
1050: AND EXISTS
1051: (SELECT 1
1052: FROM mtl_uom_conversions_view UCR

Line 1162: FROM cst_lists

1158: 0, NVL(basis_type,-1),
1159: I_BASIS_TYPE)
1160: AND CICD.inventory_item_id IN
1161: (SELECT entity_id
1162: FROM cst_lists
1163: WHERE list_id = I_LIST_ID);
1164:
1165:
1166: EXCEPTION