1554: FOR UPDATE NOWAIT;
1555:
1556: -- Row locked. Compare IN attributes to DB attributes.
1557:
1558: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_bom_designator,
1559: l_FlowSchedule_rec.alternate_bom_designator)
1560: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_rout_designator,
1561: l_FlowSchedule_rec.alternate_rout_designator)
1562: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute1,
1556: -- Row locked. Compare IN attributes to DB attributes.
1557:
1558: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_bom_designator,
1559: l_FlowSchedule_rec.alternate_bom_designator)
1560: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_rout_designator,
1561: l_FlowSchedule_rec.alternate_rout_designator)
1562: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute1,
1563: l_FlowSchedule_rec.attribute1)
1564: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute10,
1558: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_bom_designator,
1559: l_FlowSchedule_rec.alternate_bom_designator)
1560: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_rout_designator,
1561: l_FlowSchedule_rec.alternate_rout_designator)
1562: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute1,
1563: l_FlowSchedule_rec.attribute1)
1564: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute10,
1565: l_FlowSchedule_rec.attribute10)
1566: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute11,
1560: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.alternate_rout_designator,
1561: l_FlowSchedule_rec.alternate_rout_designator)
1562: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute1,
1563: l_FlowSchedule_rec.attribute1)
1564: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute10,
1565: l_FlowSchedule_rec.attribute10)
1566: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute11,
1567: l_FlowSchedule_rec.attribute11)
1568: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute12,
1562: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute1,
1563: l_FlowSchedule_rec.attribute1)
1564: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute10,
1565: l_FlowSchedule_rec.attribute10)
1566: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute11,
1567: l_FlowSchedule_rec.attribute11)
1568: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute12,
1569: l_FlowSchedule_rec.attribute12)
1570: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute13,
1564: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute10,
1565: l_FlowSchedule_rec.attribute10)
1566: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute11,
1567: l_FlowSchedule_rec.attribute11)
1568: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute12,
1569: l_FlowSchedule_rec.attribute12)
1570: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute13,
1571: l_FlowSchedule_rec.attribute13)
1572: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute14,
1566: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute11,
1567: l_FlowSchedule_rec.attribute11)
1568: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute12,
1569: l_FlowSchedule_rec.attribute12)
1570: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute13,
1571: l_FlowSchedule_rec.attribute13)
1572: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute14,
1573: l_FlowSchedule_rec.attribute14)
1574: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute15,
1568: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute12,
1569: l_FlowSchedule_rec.attribute12)
1570: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute13,
1571: l_FlowSchedule_rec.attribute13)
1572: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute14,
1573: l_FlowSchedule_rec.attribute14)
1574: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute15,
1575: l_FlowSchedule_rec.attribute15)
1576: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute2,
1570: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute13,
1571: l_FlowSchedule_rec.attribute13)
1572: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute14,
1573: l_FlowSchedule_rec.attribute14)
1574: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute15,
1575: l_FlowSchedule_rec.attribute15)
1576: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute2,
1577: l_FlowSchedule_rec.attribute2)
1578: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute3,
1572: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute14,
1573: l_FlowSchedule_rec.attribute14)
1574: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute15,
1575: l_FlowSchedule_rec.attribute15)
1576: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute2,
1577: l_FlowSchedule_rec.attribute2)
1578: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute3,
1579: l_FlowSchedule_rec.attribute3)
1580: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute4,
1574: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute15,
1575: l_FlowSchedule_rec.attribute15)
1576: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute2,
1577: l_FlowSchedule_rec.attribute2)
1578: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute3,
1579: l_FlowSchedule_rec.attribute3)
1580: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute4,
1581: l_FlowSchedule_rec.attribute4)
1582: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute5,
1576: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute2,
1577: l_FlowSchedule_rec.attribute2)
1578: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute3,
1579: l_FlowSchedule_rec.attribute3)
1580: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute4,
1581: l_FlowSchedule_rec.attribute4)
1582: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute5,
1583: l_FlowSchedule_rec.attribute5)
1584: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute6,
1578: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute3,
1579: l_FlowSchedule_rec.attribute3)
1580: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute4,
1581: l_FlowSchedule_rec.attribute4)
1582: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute5,
1583: l_FlowSchedule_rec.attribute5)
1584: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute6,
1585: l_FlowSchedule_rec.attribute6)
1586: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute7,
1580: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute4,
1581: l_FlowSchedule_rec.attribute4)
1582: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute5,
1583: l_FlowSchedule_rec.attribute5)
1584: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute6,
1585: l_FlowSchedule_rec.attribute6)
1586: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute7,
1587: l_FlowSchedule_rec.attribute7)
1588: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute8,
1582: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute5,
1583: l_FlowSchedule_rec.attribute5)
1584: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute6,
1585: l_FlowSchedule_rec.attribute6)
1586: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute7,
1587: l_FlowSchedule_rec.attribute7)
1588: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute8,
1589: l_FlowSchedule_rec.attribute8)
1590: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute9,
1584: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute6,
1585: l_FlowSchedule_rec.attribute6)
1586: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute7,
1587: l_FlowSchedule_rec.attribute7)
1588: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute8,
1589: l_FlowSchedule_rec.attribute8)
1590: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute9,
1591: l_FlowSchedule_rec.attribute9)
1592: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute_category,
1586: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute7,
1587: l_FlowSchedule_rec.attribute7)
1588: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute8,
1589: l_FlowSchedule_rec.attribute8)
1590: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute9,
1591: l_FlowSchedule_rec.attribute9)
1592: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute_category,
1593: l_FlowSchedule_rec.attribute_category)
1594: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision,
1588: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute8,
1589: l_FlowSchedule_rec.attribute8)
1590: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute9,
1591: l_FlowSchedule_rec.attribute9)
1592: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute_category,
1593: l_FlowSchedule_rec.attribute_category)
1594: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision,
1595: l_FlowSchedule_rec.bom_revision)
1596: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision_date,
1590: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute9,
1591: l_FlowSchedule_rec.attribute9)
1592: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute_category,
1593: l_FlowSchedule_rec.attribute_category)
1594: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision,
1595: l_FlowSchedule_rec.bom_revision)
1596: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision_date,
1597: l_FlowSchedule_rec.bom_revision_date)
1598: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.build_sequence,
1592: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.attribute_category,
1593: l_FlowSchedule_rec.attribute_category)
1594: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision,
1595: l_FlowSchedule_rec.bom_revision)
1596: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision_date,
1597: l_FlowSchedule_rec.bom_revision_date)
1598: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.build_sequence,
1599: l_FlowSchedule_rec.build_sequence)
1600: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.class_code,
1594: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision,
1595: l_FlowSchedule_rec.bom_revision)
1596: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision_date,
1597: l_FlowSchedule_rec.bom_revision_date)
1598: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.build_sequence,
1599: l_FlowSchedule_rec.build_sequence)
1600: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.class_code,
1601: l_FlowSchedule_rec.class_code)
1602: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_locator_id,
1596: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.bom_revision_date,
1597: l_FlowSchedule_rec.bom_revision_date)
1598: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.build_sequence,
1599: l_FlowSchedule_rec.build_sequence)
1600: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.class_code,
1601: l_FlowSchedule_rec.class_code)
1602: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_locator_id,
1603: l_FlowSchedule_rec.completion_locator_id)
1604: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_subinventory,
1598: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.build_sequence,
1599: l_FlowSchedule_rec.build_sequence)
1600: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.class_code,
1601: l_FlowSchedule_rec.class_code)
1602: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_locator_id,
1603: l_FlowSchedule_rec.completion_locator_id)
1604: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_subinventory,
1605: l_FlowSchedule_rec.completion_subinventory)
1606: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.created_by,
1600: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.class_code,
1601: l_FlowSchedule_rec.class_code)
1602: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_locator_id,
1603: l_FlowSchedule_rec.completion_locator_id)
1604: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_subinventory,
1605: l_FlowSchedule_rec.completion_subinventory)
1606: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.created_by,
1607: l_FlowSchedule_rec.created_by)
1608: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.creation_date,
1602: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_locator_id,
1603: l_FlowSchedule_rec.completion_locator_id)
1604: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_subinventory,
1605: l_FlowSchedule_rec.completion_subinventory)
1606: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.created_by,
1607: l_FlowSchedule_rec.created_by)
1608: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.creation_date,
1609: l_FlowSchedule_rec.creation_date)
1610: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.date_closed,
1604: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.completion_subinventory,
1605: l_FlowSchedule_rec.completion_subinventory)
1606: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.created_by,
1607: l_FlowSchedule_rec.created_by)
1608: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.creation_date,
1609: l_FlowSchedule_rec.creation_date)
1610: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.date_closed,
1611: l_FlowSchedule_rec.date_closed)
1612: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_class,
1606: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.created_by,
1607: l_FlowSchedule_rec.created_by)
1608: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.creation_date,
1609: l_FlowSchedule_rec.creation_date)
1610: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.date_closed,
1611: l_FlowSchedule_rec.date_closed)
1612: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_class,
1613: l_FlowSchedule_rec.demand_class)
1614: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_delivery,
1608: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.creation_date,
1609: l_FlowSchedule_rec.creation_date)
1610: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.date_closed,
1611: l_FlowSchedule_rec.date_closed)
1612: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_class,
1613: l_FlowSchedule_rec.demand_class)
1614: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_delivery,
1615: l_FlowSchedule_rec.demand_source_delivery)
1616: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_header_id,
1610: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.date_closed,
1611: l_FlowSchedule_rec.date_closed)
1612: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_class,
1613: l_FlowSchedule_rec.demand_class)
1614: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_delivery,
1615: l_FlowSchedule_rec.demand_source_delivery)
1616: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_header_id,
1617: l_FlowSchedule_rec.demand_source_header_id)
1618: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_line,
1612: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_class,
1613: l_FlowSchedule_rec.demand_class)
1614: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_delivery,
1615: l_FlowSchedule_rec.demand_source_delivery)
1616: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_header_id,
1617: l_FlowSchedule_rec.demand_source_header_id)
1618: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_line,
1619: l_FlowSchedule_rec.demand_source_line)
1620: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_type,
1614: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_delivery,
1615: l_FlowSchedule_rec.demand_source_delivery)
1616: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_header_id,
1617: l_FlowSchedule_rec.demand_source_header_id)
1618: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_line,
1619: l_FlowSchedule_rec.demand_source_line)
1620: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_type,
1621: l_FlowSchedule_rec.demand_source_type)
1622: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.kanban_card_id,
1616: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_header_id,
1617: l_FlowSchedule_rec.demand_source_header_id)
1618: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_line,
1619: l_FlowSchedule_rec.demand_source_line)
1620: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_type,
1621: l_FlowSchedule_rec.demand_source_type)
1622: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.kanban_card_id,
1623: l_FlowSchedule_rec.kanban_card_id)
1624: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
1618: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_line,
1619: l_FlowSchedule_rec.demand_source_line)
1620: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_type,
1621: l_FlowSchedule_rec.demand_source_type)
1622: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.kanban_card_id,
1623: l_FlowSchedule_rec.kanban_card_id)
1624: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
1625: l_FlowSchedule_rec.last_updated_by)
1626: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
1620: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.demand_source_type,
1621: l_FlowSchedule_rec.demand_source_type)
1622: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.kanban_card_id,
1623: l_FlowSchedule_rec.kanban_card_id)
1624: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
1625: l_FlowSchedule_rec.last_updated_by)
1626: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
1627: l_FlowSchedule_rec.last_update_date)
1628: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
1622: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.kanban_card_id,
1623: l_FlowSchedule_rec.kanban_card_id)
1624: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
1625: l_FlowSchedule_rec.last_updated_by)
1626: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
1627: l_FlowSchedule_rec.last_update_date)
1628: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
1629: l_FlowSchedule_rec.last_update_login)
1630: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
1624: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_updated_by,
1625: l_FlowSchedule_rec.last_updated_by)
1626: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
1627: l_FlowSchedule_rec.last_update_date)
1628: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
1629: l_FlowSchedule_rec.last_update_login)
1630: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
1631: l_FlowSchedule_rec.line_id)
1632: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
1626: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_date,
1627: l_FlowSchedule_rec.last_update_date)
1628: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
1629: l_FlowSchedule_rec.last_update_login)
1630: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
1631: l_FlowSchedule_rec.line_id)
1632: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
1633: l_FlowSchedule_rec.material_account)
1634: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
1628: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.last_update_login,
1629: l_FlowSchedule_rec.last_update_login)
1630: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
1631: l_FlowSchedule_rec.line_id)
1632: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
1633: l_FlowSchedule_rec.material_account)
1634: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
1635: l_FlowSchedule_rec.material_overhead_account)
1636: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
1630: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.line_id,
1631: l_FlowSchedule_rec.line_id)
1632: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
1633: l_FlowSchedule_rec.material_account)
1634: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
1635: l_FlowSchedule_rec.material_overhead_account)
1636: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
1637: l_FlowSchedule_rec.material_variance_account)
1638: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
1632: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_account,
1633: l_FlowSchedule_rec.material_account)
1634: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
1635: l_FlowSchedule_rec.material_overhead_account)
1636: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
1637: l_FlowSchedule_rec.material_variance_account)
1638: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
1639: l_FlowSchedule_rec.mps_net_quantity)
1640: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
1634: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_overhead_account,
1635: l_FlowSchedule_rec.material_overhead_account)
1636: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
1637: l_FlowSchedule_rec.material_variance_account)
1638: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
1639: l_FlowSchedule_rec.mps_net_quantity)
1640: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
1641: l_FlowSchedule_rec.mps_scheduled_cpl_date)
1642: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
1636: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.material_variance_account,
1637: l_FlowSchedule_rec.material_variance_account)
1638: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
1639: l_FlowSchedule_rec.mps_net_quantity)
1640: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
1641: l_FlowSchedule_rec.mps_scheduled_cpl_date)
1642: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
1643: l_FlowSchedule_rec.organization_id)
1644: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
1638: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_net_quantity,
1639: l_FlowSchedule_rec.mps_net_quantity)
1640: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
1641: l_FlowSchedule_rec.mps_scheduled_cpl_date)
1642: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
1643: l_FlowSchedule_rec.organization_id)
1644: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
1645: l_FlowSchedule_rec.osp_account)
1646: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
1640: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.mps_scheduled_cpl_date,
1641: l_FlowSchedule_rec.mps_scheduled_cpl_date)
1642: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
1643: l_FlowSchedule_rec.organization_id)
1644: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
1645: l_FlowSchedule_rec.osp_account)
1646: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
1647: l_FlowSchedule_rec.osp_variance_account)
1648: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
1642: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.organization_id,
1643: l_FlowSchedule_rec.organization_id)
1644: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
1645: l_FlowSchedule_rec.osp_account)
1646: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
1647: l_FlowSchedule_rec.osp_variance_account)
1648: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
1649: l_FlowSchedule_rec.overhead_account)
1650: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
1644: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_account,
1645: l_FlowSchedule_rec.osp_account)
1646: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
1647: l_FlowSchedule_rec.osp_variance_account)
1648: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
1649: l_FlowSchedule_rec.overhead_account)
1650: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
1651: l_FlowSchedule_rec.overhead_variance_account)
1652: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
1646: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.osp_variance_account,
1647: l_FlowSchedule_rec.osp_variance_account)
1648: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
1649: l_FlowSchedule_rec.overhead_account)
1650: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
1651: l_FlowSchedule_rec.overhead_variance_account)
1652: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
1653: l_FlowSchedule_rec.planned_quantity)
1654: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
1648: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_account,
1649: l_FlowSchedule_rec.overhead_account)
1650: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
1651: l_FlowSchedule_rec.overhead_variance_account)
1652: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
1653: l_FlowSchedule_rec.planned_quantity)
1654: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
1655: l_FlowSchedule_rec.primary_item_id)
1656: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
1650: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.overhead_variance_account,
1651: l_FlowSchedule_rec.overhead_variance_account)
1652: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
1653: l_FlowSchedule_rec.planned_quantity)
1654: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
1655: l_FlowSchedule_rec.primary_item_id)
1656: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
1657: l_FlowSchedule_rec.program_application_id)
1658: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
1652: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.planned_quantity,
1653: l_FlowSchedule_rec.planned_quantity)
1654: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
1655: l_FlowSchedule_rec.primary_item_id)
1656: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
1657: l_FlowSchedule_rec.program_application_id)
1658: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
1659: l_FlowSchedule_rec.program_id)
1660: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
1654: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.primary_item_id,
1655: l_FlowSchedule_rec.primary_item_id)
1656: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
1657: l_FlowSchedule_rec.program_application_id)
1658: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
1659: l_FlowSchedule_rec.program_id)
1660: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
1661: l_FlowSchedule_rec.program_update_date)
1662: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
1656: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_application_id,
1657: l_FlowSchedule_rec.program_application_id)
1658: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
1659: l_FlowSchedule_rec.program_id)
1660: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
1661: l_FlowSchedule_rec.program_update_date)
1662: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
1663: l_FlowSchedule_rec.project_id)
1664: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
1658: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_id,
1659: l_FlowSchedule_rec.program_id)
1660: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
1661: l_FlowSchedule_rec.program_update_date)
1662: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
1663: l_FlowSchedule_rec.project_id)
1664: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
1665: l_FlowSchedule_rec.quantity_completed)
1666: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
1660: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.program_update_date,
1661: l_FlowSchedule_rec.program_update_date)
1662: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
1663: l_FlowSchedule_rec.project_id)
1664: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
1665: l_FlowSchedule_rec.quantity_completed)
1666: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
1667: l_FlowSchedule_rec.request_id)
1668: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
1662: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.project_id,
1663: l_FlowSchedule_rec.project_id)
1664: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
1665: l_FlowSchedule_rec.quantity_completed)
1666: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
1667: l_FlowSchedule_rec.request_id)
1668: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
1669: l_FlowSchedule_rec.resource_account)
1670: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
1664: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.quantity_completed,
1665: l_FlowSchedule_rec.quantity_completed)
1666: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
1667: l_FlowSchedule_rec.request_id)
1668: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
1669: l_FlowSchedule_rec.resource_account)
1670: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
1671: l_FlowSchedule_rec.resource_variance_account)
1672: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
1666: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.request_id,
1667: l_FlowSchedule_rec.request_id)
1668: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
1669: l_FlowSchedule_rec.resource_account)
1670: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
1671: l_FlowSchedule_rec.resource_variance_account)
1672: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
1673: l_FlowSchedule_rec.routing_revision)
1674: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
1668: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_account,
1669: l_FlowSchedule_rec.resource_account)
1670: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
1671: l_FlowSchedule_rec.resource_variance_account)
1672: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
1673: l_FlowSchedule_rec.routing_revision)
1674: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
1675: l_FlowSchedule_rec.routing_revision_date)
1676: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
1670: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.resource_variance_account,
1671: l_FlowSchedule_rec.resource_variance_account)
1672: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
1673: l_FlowSchedule_rec.routing_revision)
1674: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
1675: l_FlowSchedule_rec.routing_revision_date)
1676: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
1677: l_FlowSchedule_rec.scheduled_completion_date)
1678: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
1672: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision,
1673: l_FlowSchedule_rec.routing_revision)
1674: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
1675: l_FlowSchedule_rec.routing_revision_date)
1676: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
1677: l_FlowSchedule_rec.scheduled_completion_date)
1678: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
1679: l_FlowSchedule_rec.scheduled_flag)
1680: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
1674: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.routing_revision_date,
1675: l_FlowSchedule_rec.routing_revision_date)
1676: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
1677: l_FlowSchedule_rec.scheduled_completion_date)
1678: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
1679: l_FlowSchedule_rec.scheduled_flag)
1680: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
1681: l_FlowSchedule_rec.scheduled_start_date)
1682: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
1676: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_completion_date,
1677: l_FlowSchedule_rec.scheduled_completion_date)
1678: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
1679: l_FlowSchedule_rec.scheduled_flag)
1680: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
1681: l_FlowSchedule_rec.scheduled_start_date)
1682: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
1683: l_FlowSchedule_rec.schedule_group_id)
1684: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
1678: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_flag,
1679: l_FlowSchedule_rec.scheduled_flag)
1680: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
1681: l_FlowSchedule_rec.scheduled_start_date)
1682: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
1683: l_FlowSchedule_rec.schedule_group_id)
1684: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
1685: l_FlowSchedule_rec.schedule_number)
1686: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
1680: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.scheduled_start_date,
1681: l_FlowSchedule_rec.scheduled_start_date)
1682: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
1683: l_FlowSchedule_rec.schedule_group_id)
1684: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
1685: l_FlowSchedule_rec.schedule_number)
1686: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
1687: l_FlowSchedule_rec.status)
1688: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
1682: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_group_id,
1683: l_FlowSchedule_rec.schedule_group_id)
1684: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
1685: l_FlowSchedule_rec.schedule_number)
1686: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
1687: l_FlowSchedule_rec.status)
1688: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
1689: l_FlowSchedule_rec.std_cost_adj_account)
1690: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.task_id,
1684: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.schedule_number,
1685: l_FlowSchedule_rec.schedule_number)
1686: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
1687: l_FlowSchedule_rec.status)
1688: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
1689: l_FlowSchedule_rec.std_cost_adj_account)
1690: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.task_id,
1691: l_FlowSchedule_rec.task_id)
1692: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.wip_entity_id,
1686: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.status,
1687: l_FlowSchedule_rec.status)
1688: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
1689: l_FlowSchedule_rec.std_cost_adj_account)
1690: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.task_id,
1691: l_FlowSchedule_rec.task_id)
1692: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.wip_entity_id,
1693: l_FlowSchedule_rec.wip_entity_id)
1694: THEN
1688: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.std_cost_adj_account,
1689: l_FlowSchedule_rec.std_cost_adj_account)
1690: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.task_id,
1691: l_FlowSchedule_rec.task_id)
1692: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec.wip_entity_id,
1693: l_FlowSchedule_rec.wip_entity_id)
1694: THEN
1695:
1696: -- Row has not changed. Set out parameter.
1766: RETURN BOOLEAN
1767: IS
1768: BEGIN
1769:
1770: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_bom_designator,
1771: p_FlowSchedule_rec2.alternate_bom_designator)
1772: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_rout_designator,
1773: p_FlowSchedule_rec2.alternate_rout_designator)
1774: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute1,
1768: BEGIN
1769:
1770: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_bom_designator,
1771: p_FlowSchedule_rec2.alternate_bom_designator)
1772: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_rout_designator,
1773: p_FlowSchedule_rec2.alternate_rout_designator)
1774: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute1,
1775: p_FlowSchedule_rec2.attribute1)
1776: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute10,
1770: IF WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_bom_designator,
1771: p_FlowSchedule_rec2.alternate_bom_designator)
1772: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_rout_designator,
1773: p_FlowSchedule_rec2.alternate_rout_designator)
1774: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute1,
1775: p_FlowSchedule_rec2.attribute1)
1776: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute10,
1777: p_FlowSchedule_rec2.attribute10)
1778: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute11,
1772: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.alternate_rout_designator,
1773: p_FlowSchedule_rec2.alternate_rout_designator)
1774: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute1,
1775: p_FlowSchedule_rec2.attribute1)
1776: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute10,
1777: p_FlowSchedule_rec2.attribute10)
1778: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute11,
1779: p_FlowSchedule_rec2.attribute11)
1780: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute12,
1774: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute1,
1775: p_FlowSchedule_rec2.attribute1)
1776: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute10,
1777: p_FlowSchedule_rec2.attribute10)
1778: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute11,
1779: p_FlowSchedule_rec2.attribute11)
1780: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute12,
1781: p_FlowSchedule_rec2.attribute12)
1782: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute13,
1776: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute10,
1777: p_FlowSchedule_rec2.attribute10)
1778: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute11,
1779: p_FlowSchedule_rec2.attribute11)
1780: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute12,
1781: p_FlowSchedule_rec2.attribute12)
1782: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute13,
1783: p_FlowSchedule_rec2.attribute13)
1784: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute14,
1778: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute11,
1779: p_FlowSchedule_rec2.attribute11)
1780: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute12,
1781: p_FlowSchedule_rec2.attribute12)
1782: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute13,
1783: p_FlowSchedule_rec2.attribute13)
1784: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute14,
1785: p_FlowSchedule_rec2.attribute14)
1786: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute15,
1780: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute12,
1781: p_FlowSchedule_rec2.attribute12)
1782: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute13,
1783: p_FlowSchedule_rec2.attribute13)
1784: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute14,
1785: p_FlowSchedule_rec2.attribute14)
1786: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute15,
1787: p_FlowSchedule_rec2.attribute15)
1788: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute2,
1782: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute13,
1783: p_FlowSchedule_rec2.attribute13)
1784: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute14,
1785: p_FlowSchedule_rec2.attribute14)
1786: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute15,
1787: p_FlowSchedule_rec2.attribute15)
1788: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute2,
1789: p_FlowSchedule_rec2.attribute2)
1790: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute3,
1784: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute14,
1785: p_FlowSchedule_rec2.attribute14)
1786: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute15,
1787: p_FlowSchedule_rec2.attribute15)
1788: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute2,
1789: p_FlowSchedule_rec2.attribute2)
1790: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute3,
1791: p_FlowSchedule_rec2.attribute3)
1792: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute4,
1786: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute15,
1787: p_FlowSchedule_rec2.attribute15)
1788: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute2,
1789: p_FlowSchedule_rec2.attribute2)
1790: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute3,
1791: p_FlowSchedule_rec2.attribute3)
1792: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute4,
1793: p_FlowSchedule_rec2.attribute4)
1794: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute5,
1788: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute2,
1789: p_FlowSchedule_rec2.attribute2)
1790: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute3,
1791: p_FlowSchedule_rec2.attribute3)
1792: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute4,
1793: p_FlowSchedule_rec2.attribute4)
1794: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute5,
1795: p_FlowSchedule_rec2.attribute5)
1796: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute6,
1790: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute3,
1791: p_FlowSchedule_rec2.attribute3)
1792: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute4,
1793: p_FlowSchedule_rec2.attribute4)
1794: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute5,
1795: p_FlowSchedule_rec2.attribute5)
1796: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute6,
1797: p_FlowSchedule_rec2.attribute6)
1798: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute7,
1792: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute4,
1793: p_FlowSchedule_rec2.attribute4)
1794: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute5,
1795: p_FlowSchedule_rec2.attribute5)
1796: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute6,
1797: p_FlowSchedule_rec2.attribute6)
1798: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute7,
1799: p_FlowSchedule_rec2.attribute7)
1800: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute8,
1794: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute5,
1795: p_FlowSchedule_rec2.attribute5)
1796: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute6,
1797: p_FlowSchedule_rec2.attribute6)
1798: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute7,
1799: p_FlowSchedule_rec2.attribute7)
1800: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute8,
1801: p_FlowSchedule_rec2.attribute8)
1802: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute9,
1796: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute6,
1797: p_FlowSchedule_rec2.attribute6)
1798: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute7,
1799: p_FlowSchedule_rec2.attribute7)
1800: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute8,
1801: p_FlowSchedule_rec2.attribute8)
1802: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute9,
1803: p_FlowSchedule_rec2.attribute9)
1804: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute_category,
1798: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute7,
1799: p_FlowSchedule_rec2.attribute7)
1800: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute8,
1801: p_FlowSchedule_rec2.attribute8)
1802: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute9,
1803: p_FlowSchedule_rec2.attribute9)
1804: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute_category,
1805: p_FlowSchedule_rec2.attribute_category)
1806: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision,
1800: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute8,
1801: p_FlowSchedule_rec2.attribute8)
1802: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute9,
1803: p_FlowSchedule_rec2.attribute9)
1804: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute_category,
1805: p_FlowSchedule_rec2.attribute_category)
1806: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision,
1807: p_FlowSchedule_rec2.bom_revision)
1808: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision_date,
1802: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute9,
1803: p_FlowSchedule_rec2.attribute9)
1804: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute_category,
1805: p_FlowSchedule_rec2.attribute_category)
1806: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision,
1807: p_FlowSchedule_rec2.bom_revision)
1808: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision_date,
1809: p_FlowSchedule_rec2.bom_revision_date)
1810: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.build_sequence,
1804: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.attribute_category,
1805: p_FlowSchedule_rec2.attribute_category)
1806: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision,
1807: p_FlowSchedule_rec2.bom_revision)
1808: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision_date,
1809: p_FlowSchedule_rec2.bom_revision_date)
1810: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.build_sequence,
1811: p_FlowSchedule_rec2.build_sequence)
1812: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.class_code,
1806: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision,
1807: p_FlowSchedule_rec2.bom_revision)
1808: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision_date,
1809: p_FlowSchedule_rec2.bom_revision_date)
1810: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.build_sequence,
1811: p_FlowSchedule_rec2.build_sequence)
1812: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.class_code,
1813: p_FlowSchedule_rec2.class_code)
1814: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_locator_id,
1808: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.bom_revision_date,
1809: p_FlowSchedule_rec2.bom_revision_date)
1810: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.build_sequence,
1811: p_FlowSchedule_rec2.build_sequence)
1812: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.class_code,
1813: p_FlowSchedule_rec2.class_code)
1814: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_locator_id,
1815: p_FlowSchedule_rec2.completion_locator_id)
1816: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_subinventory,
1810: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.build_sequence,
1811: p_FlowSchedule_rec2.build_sequence)
1812: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.class_code,
1813: p_FlowSchedule_rec2.class_code)
1814: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_locator_id,
1815: p_FlowSchedule_rec2.completion_locator_id)
1816: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_subinventory,
1817: p_FlowSchedule_rec2.completion_subinventory)
1818: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.created_by,
1812: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.class_code,
1813: p_FlowSchedule_rec2.class_code)
1814: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_locator_id,
1815: p_FlowSchedule_rec2.completion_locator_id)
1816: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_subinventory,
1817: p_FlowSchedule_rec2.completion_subinventory)
1818: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.created_by,
1819: p_FlowSchedule_rec2.created_by)
1820: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.creation_date,
1814: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_locator_id,
1815: p_FlowSchedule_rec2.completion_locator_id)
1816: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_subinventory,
1817: p_FlowSchedule_rec2.completion_subinventory)
1818: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.created_by,
1819: p_FlowSchedule_rec2.created_by)
1820: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.creation_date,
1821: p_FlowSchedule_rec2.creation_date)
1822: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.date_closed,
1816: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.completion_subinventory,
1817: p_FlowSchedule_rec2.completion_subinventory)
1818: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.created_by,
1819: p_FlowSchedule_rec2.created_by)
1820: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.creation_date,
1821: p_FlowSchedule_rec2.creation_date)
1822: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.date_closed,
1823: p_FlowSchedule_rec2.date_closed)
1824: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_class,
1818: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.created_by,
1819: p_FlowSchedule_rec2.created_by)
1820: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.creation_date,
1821: p_FlowSchedule_rec2.creation_date)
1822: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.date_closed,
1823: p_FlowSchedule_rec2.date_closed)
1824: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_class,
1825: p_FlowSchedule_rec2.demand_class)
1826: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_delivery,
1820: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.creation_date,
1821: p_FlowSchedule_rec2.creation_date)
1822: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.date_closed,
1823: p_FlowSchedule_rec2.date_closed)
1824: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_class,
1825: p_FlowSchedule_rec2.demand_class)
1826: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_delivery,
1827: p_FlowSchedule_rec2.demand_source_delivery)
1828: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_header_id,
1822: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.date_closed,
1823: p_FlowSchedule_rec2.date_closed)
1824: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_class,
1825: p_FlowSchedule_rec2.demand_class)
1826: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_delivery,
1827: p_FlowSchedule_rec2.demand_source_delivery)
1828: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_header_id,
1829: p_FlowSchedule_rec2.demand_source_header_id)
1830: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_line,
1824: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_class,
1825: p_FlowSchedule_rec2.demand_class)
1826: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_delivery,
1827: p_FlowSchedule_rec2.demand_source_delivery)
1828: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_header_id,
1829: p_FlowSchedule_rec2.demand_source_header_id)
1830: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_line,
1831: p_FlowSchedule_rec2.demand_source_line)
1832: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_type,
1826: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_delivery,
1827: p_FlowSchedule_rec2.demand_source_delivery)
1828: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_header_id,
1829: p_FlowSchedule_rec2.demand_source_header_id)
1830: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_line,
1831: p_FlowSchedule_rec2.demand_source_line)
1832: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_type,
1833: p_FlowSchedule_rec2.demand_source_type)
1834: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.kanban_card_id,
1828: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_header_id,
1829: p_FlowSchedule_rec2.demand_source_header_id)
1830: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_line,
1831: p_FlowSchedule_rec2.demand_source_line)
1832: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_type,
1833: p_FlowSchedule_rec2.demand_source_type)
1834: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.kanban_card_id,
1835: p_FlowSchedule_rec2.kanban_card_id)
1836: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
1830: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_line,
1831: p_FlowSchedule_rec2.demand_source_line)
1832: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_type,
1833: p_FlowSchedule_rec2.demand_source_type)
1834: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.kanban_card_id,
1835: p_FlowSchedule_rec2.kanban_card_id)
1836: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
1837: p_FlowSchedule_rec2.last_updated_by)
1838: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
1832: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.demand_source_type,
1833: p_FlowSchedule_rec2.demand_source_type)
1834: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.kanban_card_id,
1835: p_FlowSchedule_rec2.kanban_card_id)
1836: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
1837: p_FlowSchedule_rec2.last_updated_by)
1838: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
1839: p_FlowSchedule_rec2.last_update_date)
1840: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
1834: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.kanban_card_id,
1835: p_FlowSchedule_rec2.kanban_card_id)
1836: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
1837: p_FlowSchedule_rec2.last_updated_by)
1838: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
1839: p_FlowSchedule_rec2.last_update_date)
1840: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
1841: p_FlowSchedule_rec2.last_update_login)
1842: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
1836: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_updated_by,
1837: p_FlowSchedule_rec2.last_updated_by)
1838: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
1839: p_FlowSchedule_rec2.last_update_date)
1840: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
1841: p_FlowSchedule_rec2.last_update_login)
1842: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
1843: p_FlowSchedule_rec2.line_id)
1844: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
1838: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_date,
1839: p_FlowSchedule_rec2.last_update_date)
1840: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
1841: p_FlowSchedule_rec2.last_update_login)
1842: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
1843: p_FlowSchedule_rec2.line_id)
1844: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
1845: p_FlowSchedule_rec2.material_account)
1846: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
1840: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.last_update_login,
1841: p_FlowSchedule_rec2.last_update_login)
1842: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
1843: p_FlowSchedule_rec2.line_id)
1844: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
1845: p_FlowSchedule_rec2.material_account)
1846: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
1847: p_FlowSchedule_rec2.material_overhead_account)
1848: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
1842: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.line_id,
1843: p_FlowSchedule_rec2.line_id)
1844: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
1845: p_FlowSchedule_rec2.material_account)
1846: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
1847: p_FlowSchedule_rec2.material_overhead_account)
1848: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
1849: p_FlowSchedule_rec2.material_variance_account)
1850: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
1844: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_account,
1845: p_FlowSchedule_rec2.material_account)
1846: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
1847: p_FlowSchedule_rec2.material_overhead_account)
1848: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
1849: p_FlowSchedule_rec2.material_variance_account)
1850: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
1851: p_FlowSchedule_rec2.mps_net_quantity)
1852: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
1846: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_overhead_account,
1847: p_FlowSchedule_rec2.material_overhead_account)
1848: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
1849: p_FlowSchedule_rec2.material_variance_account)
1850: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
1851: p_FlowSchedule_rec2.mps_net_quantity)
1852: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
1853: p_FlowSchedule_rec2.mps_scheduled_cpl_date)
1854: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
1848: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.material_variance_account,
1849: p_FlowSchedule_rec2.material_variance_account)
1850: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
1851: p_FlowSchedule_rec2.mps_net_quantity)
1852: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
1853: p_FlowSchedule_rec2.mps_scheduled_cpl_date)
1854: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
1855: p_FlowSchedule_rec2.organization_id)
1856: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
1850: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_net_quantity,
1851: p_FlowSchedule_rec2.mps_net_quantity)
1852: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
1853: p_FlowSchedule_rec2.mps_scheduled_cpl_date)
1854: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
1855: p_FlowSchedule_rec2.organization_id)
1856: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
1857: p_FlowSchedule_rec2.osp_account)
1858: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
1852: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.mps_scheduled_cpl_date,
1853: p_FlowSchedule_rec2.mps_scheduled_cpl_date)
1854: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
1855: p_FlowSchedule_rec2.organization_id)
1856: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
1857: p_FlowSchedule_rec2.osp_account)
1858: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
1859: p_FlowSchedule_rec2.osp_variance_account)
1860: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
1854: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.organization_id,
1855: p_FlowSchedule_rec2.organization_id)
1856: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
1857: p_FlowSchedule_rec2.osp_account)
1858: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
1859: p_FlowSchedule_rec2.osp_variance_account)
1860: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
1861: p_FlowSchedule_rec2.overhead_account)
1862: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
1856: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_account,
1857: p_FlowSchedule_rec2.osp_account)
1858: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
1859: p_FlowSchedule_rec2.osp_variance_account)
1860: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
1861: p_FlowSchedule_rec2.overhead_account)
1862: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
1863: p_FlowSchedule_rec2.overhead_variance_account)
1864: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
1858: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.osp_variance_account,
1859: p_FlowSchedule_rec2.osp_variance_account)
1860: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
1861: p_FlowSchedule_rec2.overhead_account)
1862: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
1863: p_FlowSchedule_rec2.overhead_variance_account)
1864: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
1865: p_FlowSchedule_rec2.planned_quantity)
1866: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
1860: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_account,
1861: p_FlowSchedule_rec2.overhead_account)
1862: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
1863: p_FlowSchedule_rec2.overhead_variance_account)
1864: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
1865: p_FlowSchedule_rec2.planned_quantity)
1866: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
1867: p_FlowSchedule_rec2.primary_item_id)
1868: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
1862: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.overhead_variance_account,
1863: p_FlowSchedule_rec2.overhead_variance_account)
1864: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
1865: p_FlowSchedule_rec2.planned_quantity)
1866: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
1867: p_FlowSchedule_rec2.primary_item_id)
1868: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
1869: p_FlowSchedule_rec2.program_application_id)
1870: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
1864: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.planned_quantity,
1865: p_FlowSchedule_rec2.planned_quantity)
1866: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
1867: p_FlowSchedule_rec2.primary_item_id)
1868: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
1869: p_FlowSchedule_rec2.program_application_id)
1870: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
1871: p_FlowSchedule_rec2.program_id)
1872: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
1866: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.primary_item_id,
1867: p_FlowSchedule_rec2.primary_item_id)
1868: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
1869: p_FlowSchedule_rec2.program_application_id)
1870: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
1871: p_FlowSchedule_rec2.program_id)
1872: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
1873: p_FlowSchedule_rec2.program_update_date)
1874: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
1868: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_application_id,
1869: p_FlowSchedule_rec2.program_application_id)
1870: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
1871: p_FlowSchedule_rec2.program_id)
1872: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
1873: p_FlowSchedule_rec2.program_update_date)
1874: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
1875: p_FlowSchedule_rec2.project_id)
1876: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
1870: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_id,
1871: p_FlowSchedule_rec2.program_id)
1872: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
1873: p_FlowSchedule_rec2.program_update_date)
1874: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
1875: p_FlowSchedule_rec2.project_id)
1876: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
1877: p_FlowSchedule_rec2.quantity_completed)
1878: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
1872: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.program_update_date,
1873: p_FlowSchedule_rec2.program_update_date)
1874: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
1875: p_FlowSchedule_rec2.project_id)
1876: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
1877: p_FlowSchedule_rec2.quantity_completed)
1878: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
1879: p_FlowSchedule_rec2.request_id)
1880: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
1874: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.project_id,
1875: p_FlowSchedule_rec2.project_id)
1876: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
1877: p_FlowSchedule_rec2.quantity_completed)
1878: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
1879: p_FlowSchedule_rec2.request_id)
1880: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
1881: p_FlowSchedule_rec2.resource_account)
1882: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
1876: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.quantity_completed,
1877: p_FlowSchedule_rec2.quantity_completed)
1878: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
1879: p_FlowSchedule_rec2.request_id)
1880: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
1881: p_FlowSchedule_rec2.resource_account)
1882: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
1883: p_FlowSchedule_rec2.resource_variance_account)
1884: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
1878: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.request_id,
1879: p_FlowSchedule_rec2.request_id)
1880: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
1881: p_FlowSchedule_rec2.resource_account)
1882: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
1883: p_FlowSchedule_rec2.resource_variance_account)
1884: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
1885: p_FlowSchedule_rec2.routing_revision)
1886: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
1880: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_account,
1881: p_FlowSchedule_rec2.resource_account)
1882: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
1883: p_FlowSchedule_rec2.resource_variance_account)
1884: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
1885: p_FlowSchedule_rec2.routing_revision)
1886: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
1887: p_FlowSchedule_rec2.routing_revision_date)
1888: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
1882: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.resource_variance_account,
1883: p_FlowSchedule_rec2.resource_variance_account)
1884: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
1885: p_FlowSchedule_rec2.routing_revision)
1886: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
1887: p_FlowSchedule_rec2.routing_revision_date)
1888: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
1889: p_FlowSchedule_rec2.scheduled_completion_date)
1890: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
1884: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision,
1885: p_FlowSchedule_rec2.routing_revision)
1886: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
1887: p_FlowSchedule_rec2.routing_revision_date)
1888: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
1889: p_FlowSchedule_rec2.scheduled_completion_date)
1890: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
1891: p_FlowSchedule_rec2.scheduled_flag)
1892: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
1886: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.routing_revision_date,
1887: p_FlowSchedule_rec2.routing_revision_date)
1888: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
1889: p_FlowSchedule_rec2.scheduled_completion_date)
1890: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
1891: p_FlowSchedule_rec2.scheduled_flag)
1892: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
1893: p_FlowSchedule_rec2.scheduled_start_date)
1894: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
1888: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_completion_date,
1889: p_FlowSchedule_rec2.scheduled_completion_date)
1890: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
1891: p_FlowSchedule_rec2.scheduled_flag)
1892: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
1893: p_FlowSchedule_rec2.scheduled_start_date)
1894: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
1895: p_FlowSchedule_rec2.schedule_group_id)
1896: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
1890: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_flag,
1891: p_FlowSchedule_rec2.scheduled_flag)
1892: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
1893: p_FlowSchedule_rec2.scheduled_start_date)
1894: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
1895: p_FlowSchedule_rec2.schedule_group_id)
1896: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
1897: p_FlowSchedule_rec2.schedule_number)
1898: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
1892: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.scheduled_start_date,
1893: p_FlowSchedule_rec2.scheduled_start_date)
1894: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
1895: p_FlowSchedule_rec2.schedule_group_id)
1896: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
1897: p_FlowSchedule_rec2.schedule_number)
1898: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
1899: p_FlowSchedule_rec2.status)
1900: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
1894: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_group_id,
1895: p_FlowSchedule_rec2.schedule_group_id)
1896: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
1897: p_FlowSchedule_rec2.schedule_number)
1898: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
1899: p_FlowSchedule_rec2.status)
1900: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
1901: p_FlowSchedule_rec2.std_cost_adj_account)
1902: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.task_id,
1896: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.schedule_number,
1897: p_FlowSchedule_rec2.schedule_number)
1898: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
1899: p_FlowSchedule_rec2.status)
1900: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
1901: p_FlowSchedule_rec2.std_cost_adj_account)
1902: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.task_id,
1903: p_FlowSchedule_rec2.task_id)
1904: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.wip_entity_id,
1898: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.status,
1899: p_FlowSchedule_rec2.status)
1900: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
1901: p_FlowSchedule_rec2.std_cost_adj_account)
1902: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.task_id,
1903: p_FlowSchedule_rec2.task_id)
1904: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.wip_entity_id,
1905: p_FlowSchedule_rec2.wip_entity_id)
1906: THEN
1900: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.std_cost_adj_account,
1901: p_FlowSchedule_rec2.std_cost_adj_account)
1902: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.task_id,
1903: p_FlowSchedule_rec2.task_id)
1904: AND WIP_GLOBALS.Equal(p_FlowSchedule_rec1.wip_entity_id,
1905: p_FlowSchedule_rec2.wip_entity_id)
1906: THEN
1907: RETURN TRUE;
1908: ELSE