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 130: DELETE FROM cst_lists L

126: /*===============================================================*/
127: /* Removed any item from the list where there is no PO receipt */
128: /* Bug 13497932 - use exists, count, and sum to exclude zero quantity items */
129: /*===============================================================*/
130: DELETE FROM cst_lists L
131: WHERE L.list_id = I_LIST_ID
132: AND EXISTS (
133: SELECT /*+ NO_UNNEST */ 'X'
134: FROM mtl_material_transactions M

Line 269: FROM cst_lists L

265: AND rollup_source_type = 1 /* User Defined */
266: AND EXISTS
267: (
268: SELECT 'X'
269: FROM cst_lists L
270: WHERE L.list_id = I_LIST_ID
271: AND L.entity_id = CICD.inventory_item_id
272: )
273: ;

Line 320: DELETE FROM cst_lists L

316:
317: /*===============================================================*/
318: /* Removed any item from the list where there is no PO receipt */
319: /*===============================================================*/
320: DELETE FROM cst_lists L
321: WHERE L.list_id = I_LIST_ID
322: AND NOT EXISTS (
323: SELECT 'X'
324: FROM mtl_material_transactions M

Line 482: FROM cst_lists L

478:
479: AND EXISTS
480: (
481: SELECT 'X'
482: FROM cst_lists L
483: WHERE L.list_id = I_LIST_ID
484: AND L.entity_id = CICD.inventory_item_id
485: )
486: ;

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

529: CSTPUTIL.CSTPUGCI(I_ORG_ID, ROUND_UNIT, PRECISION, EXT_PREC);
530:
531: /*=============================================================================*/
532: /* Populate the global temporary table cst_open_pos_temp with all of the items */
533: /* in cst_lists that have open POs associated with them. This data will be */
534: /* used below to update the item cost and usage rate in CICD. */
535: /*=============================================================================*/
536:
537: /* Bug 3589032 - Instead of inserting the open POs directly into the temp

Line 549: FROM cst_lists

545: inventory_item_id)
546: SELECT
547: NULL
548: , entity_id
549: FROM cst_lists
550: WHERE list_id = I_LIST_ID;
551:
552:
553: UPDATE cst_open_pos_temp COPT

Line 615: DELETE FROM cst_lists

611: /* Now delete all items from the temp tables where there were no OPEN POs found */
612: DELETE FROM cst_open_pos_temp
613: WHERE usage_rate_or_amount IS NULL;
614:
615: DELETE FROM cst_lists
616: WHERE list_id = I_LIST_ID
617: AND entity_id NOT IN (SELECT inventory_item_id FROM cst_open_pos_temp);
618:
619: /*===============================================================*/

Line 740: FROM CST_LISTS L

736: AND COST_TYPE_ID = I_COST_TYPE_ID
737: AND EXISTS
738: (
739: SELECT 'X'
740: FROM CST_LISTS L
741: WHERE L.LIST_ID = I_LIST_ID
742: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
743: )
744: ;

Line 763: FROM CST_LISTS L

759: AND COST_TYPE_ID = I_COST_TYPE_ID
760: AND EXISTS
761: (
762: SELECT 'X'
763: FROM CST_LISTS L
764: WHERE L.LIST_ID = I_LIST_ID
765: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
766: )
767: ;

Line 844: FROM CST_LISTS L

840: I_RESOURCE_ID)
841: AND A.INVENTORY_ITEM_ID IN
842: (
843: SELECT ENTITY_ID
844: FROM CST_LISTS L
845: WHERE LIST_ID = I_LIST_ID
846: )
847: ;
848:

Line 923: FROM CST_LISTS L

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

Line 987: FROM CST_LISTS L

983: AND COST_TYPE_ID = I_COST_TYPE_ID
984: AND EXISTS
985: (
986: SELECT 'X'
987: FROM CST_LISTS L
988: WHERE L.LIST_ID = I_LIST_ID
989: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
990: )
991: ;

Line 1020: FROM CST_LISTS L

1016: AND COST_TYPE_ID = I_COST_TYPE_ID
1017: AND EXISTS
1018: (
1019: SELECT 'X'
1020: FROM CST_LISTS L
1021: WHERE L.LIST_ID = I_LIST_ID
1022: AND L.ENTITY_ID = A.INVENTORY_ITEM_ID
1023: )
1024: ;

Line 1089: DELETE FROM cst_lists L

1085: Zero or negative item Costs.After having done this the above statement
1086: is redundant
1087: +==============================================================*/
1088:
1089: DELETE FROM cst_lists L
1090: WHERE L.list_id = I_LIST_ID
1091: AND EXISTS
1092: (SELECT 1
1093: FROM mtl_uom_conversions_view UCR

Line 1233: FROM cst_lists

1229: 0, NVL(basis_type,-1),
1230: I_BASIS_TYPE)
1231: AND CICD.inventory_item_id IN
1232: (SELECT entity_id
1233: FROM cst_lists
1234: WHERE list_id = I_LIST_ID);
1235:
1236:
1237: EXCEPTION