DBA Data[Home] [Help]

APPS.OKE_DELIVERABLE_ACTIONS_PKG dependencies on OKE_DELIVERABLES_B

Line 68: , oke_deliverables_b oke

64: FROM dual
65: WHERE NOT EXISTS (
66: SELECT 1
67: FROM mrp_schedule_items mrp
68: , oke_deliverables_b oke
69: , oke_deliverable_actions oka
70: WHERE oka.action_id = p_action_id
71: AND oke.deliverable_id = oka.deliverable_id
72: AND mrp.inventory_item_id = oke.item_id

Line 144: FROM oke_deliverables_b b

140: , b.project_id
141: , c.task_id
142: , b.unit_number
143: , c.deliverable_id
144: FROM oke_deliverables_b b
145: , oke_deliverable_actions c
146: WHERE c.action_id = p_action_id
147: AND b.deliverable_id = c.deliverable_id;
148:

Line 184: FROM oke_deliverables_b b

180: , sysdate
181: , fnd_global.user_id
182: , fnd_global.login_id
183: , d.maximum_bom_level
184: FROM oke_deliverables_b b
185: , oke_deliverable_actions c
186: , bom_parameters d
187: WHERE c.action_id = p_action_id
188: AND c.deliverable_id = b.deliverable_id

Line 294: FROM oke_deliverables_b b

290: , mrp_calendar.prev_work_day(c.ship_from_org_id
291: , 1
292: , c.expected_date) workdate
293: , d.primary_uom_code
294: FROM oke_deliverables_b b
295: , oke_deliverable_actions c
296: , mtl_system_items d
297: WHERE c.action_id = p_action_id
298: AND b.deliverable_id = c.deliverable_id

Line 494: FROM oke_deliverables_b b

490: , c.weight
491: , c.weight_uom_code
492: , nvl(b.currency_code, c.currency_code) currency_code
493: , c.task_id
494: FROM oke_deliverables_b b
495: , oke_deliverable_actions c
496: WHERE c.action_id = p_action_id
497: AND b.deliverable_id = c.deliverable_id;
498:

Line 722: FROM oke_deliverables_b b

718: , c.action_id
719: , b.unit_number
720: , c.rate_date
721: , c.rate_type
722: FROM oke_deliverables_b b
723: , oke_deliverable_actions c
724: WHERE c.action_id = p_action_id
725: AND b.deliverable_id = c.deliverable_id;
726:

Line 999: FROM oke_deliverables_b

995: L_Action_ID NUMBER;
996:
997: CURSOR c IS
998: SELECT deliverable_id
999: FROM oke_deliverables_b
1000: WHERE source_deliverable_id = p_deliverable_id;
1001:
1002: CURSOR c_act IS
1003: SELECT pa_action_id

Line 1021: DELETE FROM oke_deliverables_b

1017:
1018: DELETE FROM oke_deliverables_tl
1019: WHERE deliverable_id = l_deliverable_id;
1020:
1021: DELETE FROM oke_deliverables_b
1022: WHERE deliverable_id = l_deliverable_id;
1023:
1024: END IF;
1025: