APPS.CSTPPWCL dependencies on WIP_ENTITIES

Line 38: -- Cursor to process period Job close transaction for all wip entities

34: -- for that period.
35: -----------------------------------------------------------------------------
36:
37: -----------------------------------------------------------------------------
38: -- Cursor to process period Job close transaction for all wip entities
39: -- you could have more than one job close transaction in the same
40: -- period but we are concerned with just one because at the end of
41: -- the period we flush out everything from the job if there is at
42: -- least one job close txn in that period. There would be actual cost

Line 60: wip_entities we

56: SELECT NVL(MAX(wt.transaction_id),-1) txn_id,
57: wt.organization_id org_id,
58: wt.wip_entity_id entity_id
59: FROM wip_transactions wt,
60: wip_entities we
61: WHERE wt.transaction_date BETWEEN TRUNC(p_start_date)
62: AND (TRUNC(p_end_date) + 0.99999)
63: AND wt.transaction_type = 6 --Job Close
64: AND we.wip_entity_id = wt.wip_entity_id

Line 96: -- Cursor to identify those WIP entities that do not have any assembly

92: AND wppb.cost_group_id = p_cost_group_id
93: AND wppb.wip_entity_type = 2; -- Rep. Svhedule
94:
95: -----------------------------------------------------------------------------
96: -- Cursor to identify those WIP entities that do not have any assembly
97: -- reference. Such entities will be flushed out at the end of the period
98: -- as a period expense.
99: -----------------------------------------------------------------------------
100:

Line 125: FROM wip_entities we

121: WHERE wppb.pac_period_id = p_pac_period_id
122: AND wppb.cost_group_id = p_cost_group_id
123: AND EXISTS
124: ( SELECT 'X'
125: FROM wip_entities we
126: WHERE we.wip_entity_id = wppb.wip_entity_id
127: AND we.primary_item_id IS NULL
128: AND we.entity_type not in (6,7) -- Added for R12 PAC eAM enhancement to
129: -- exclude eAM jobs at the PAC period close