APPS.WIP_WS_UTIL dependencies on FND_ATTACHED_DOCUMENTS

Line 1548: from FND_ATTACHED_DOCUMENTS

1544: begin
1545: select 1 into l_attach_count
1546: from dual
1547: where exists (select 1
1548: from FND_ATTACHED_DOCUMENTS
1549: where entity_name = 'WIP_DISCRETE_JOBS'
1550: and pk1_value = p_job_id
1551: and pk2_value = p_org_id
1552: and rownum = 1);

Line 1563: from FND_ATTACHED_DOCUMENTS

1559: begin
1560: select 1 into l_attach_count
1561: from dual
1562: where exists (select 1
1563: from FND_ATTACHED_DOCUMENTS
1564: where entity_name = 'WIP_DISCRETE_OPERATIONS'
1565: and pk1_value = p_job_id
1566: and pk2_value = p_op_seq
1567: and pk3_value = p_org_id

Line 1579: from FND_ATTACHED_DOCUMENTS fad,

1575: begin
1576: select 1 into l_attach_count
1577: from dual
1578: where exists (select 1
1579: from FND_ATTACHED_DOCUMENTS fad,
1580: wip_entities we
1581: where fad.entity_name = 'MTL_SYSTEM_ITEMS'
1582: and fad.pk1_value = p_org_id
1583: and fad.pk2_value = we.primary_item_id

Line 1597: from FND_ATTACHED_DOCUMENTS fad,

1593: begin
1594: select 1 into l_attach_count
1595: from dual
1596: where exists (select 1
1597: from FND_ATTACHED_DOCUMENTS fad,
1598: wip_discrete_jobs wdj
1599: where fad.entity_name = 'BOM_BILL_OF_MATERIALS'
1600: and fad.pk1_value = wdj.common_bom_sequence_id
1601: and wdj.wip_entity_id = p_job_id

Line 1614: from FND_ATTACHED_DOCUMENTS fad,

1610: begin
1611: select 1 into l_attach_count
1612: from dual
1613: where exists (select 1
1614: from FND_ATTACHED_DOCUMENTS fad,
1615: wip_discrete_jobs wdj
1616: where fad.entity_name = 'BOM_OPERATIONAL_ROUTINGS'
1617: and fad.pk1_value = wdj.common_routing_sequence_id
1618: and wdj.wip_entity_id = p_job_id

Line 1631: from FND_ATTACHED_DOCUMENTS fad

1627: begin
1628: select 1 into l_attach_count
1629: from dual
1630: where exists (select 1
1631: from FND_ATTACHED_DOCUMENTS fad
1632: where fad.entity_name = 'MTL_SYSTEM_ITEMS'
1633: and pk1_value = p_org_id
1634: and pk2_value IN ( select inventory_item_id
1635: from wip_requirement_operations

Line 1650: from FND_ATTACHED_DOCUMENTS fad

1646: begin
1647: select 1 into l_attach_count
1648: from dual
1649: where exists (select 1
1650: from FND_ATTACHED_DOCUMENTS fad
1651: where fad.entity_name = 'OE_ORDER_HEADERS'
1652: and pk1_value IN ( select header_id
1653: from oe_order_lines_all
1654: where line_id in ( select mr.demand_source_line_id

Line 1672: from FND_ATTACHED_DOCUMENTS fad

1668: begin
1669: select 1 into l_attach_count
1670: from dual
1671: where exists (select 1
1672: from FND_ATTACHED_DOCUMENTS fad
1673: where fad.entity_name = 'OE_ORDER_LINES'
1674: and pk1_value IN ( select mr.demand_source_line_id
1675: from mtl_reservations mr
1676: where mr.demand_source_type_id in (2,8)