1904: FOR UPDATE NOWAIT;
1905:
1906: -- Row locked. Compare IN attributes to DB attributes.
1907:
1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1906: -- Row locked. Compare IN attributes to DB attributes.
1907:
1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1908: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_bom_designator,
1909: l_DiscreteJob_rec.alternate_bom_designator)
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1910: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.alternate_rout_designator,
1911: l_DiscreteJob_rec.alternate_rout_designator)
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1912: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute1,
1913: l_DiscreteJob_rec.attribute1)
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1914: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute10,
1915: l_DiscreteJob_rec.attribute10)
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1916: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute11,
1917: l_DiscreteJob_rec.attribute11)
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1918: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute12,
1919: l_DiscreteJob_rec.attribute12)
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1920: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute13,
1921: l_DiscreteJob_rec.attribute13)
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1922: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute14,
1923: l_DiscreteJob_rec.attribute14)
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1924: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute15,
1925: l_DiscreteJob_rec.attribute15)
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1926: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute2,
1927: l_DiscreteJob_rec.attribute2)
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1928: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute3,
1929: l_DiscreteJob_rec.attribute3)
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1930: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute4,
1931: l_DiscreteJob_rec.attribute4)
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1932: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute5,
1933: l_DiscreteJob_rec.attribute5)
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1934: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute6,
1935: l_DiscreteJob_rec.attribute6)
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1936: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute7,
1937: l_DiscreteJob_rec.attribute7)
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1938: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute8,
1939: l_DiscreteJob_rec.attribute8)
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1940: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute9,
1941: l_DiscreteJob_rec.attribute9)
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1942: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.attribute_category,
1943: l_DiscreteJob_rec.attribute_category)
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1944: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_reference_id,
1945: l_DiscreteJob_rec.bom_reference_id)
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1946: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision,
1947: l_DiscreteJob_rec.bom_revision)
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1948: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.bom_revision_date,
1949: l_DiscreteJob_rec.bom_revision_date)
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1950: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.build_sequence,
1951: l_DiscreteJob_rec.build_sequence)
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1952: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.class_code,
1953: l_DiscreteJob_rec.class_code)
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1954: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_bom_sequence_id,
1955: l_DiscreteJob_rec.common_bom_sequence_id)
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1956: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.common_rout_sequence_id,
1957: l_DiscreteJob_rec.common_rout_sequence_id)
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1958: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_locator_id,
1959: l_DiscreteJob_rec.completion_locator_id)
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1960: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.completion_subinventory,
1961: l_DiscreteJob_rec.completion_subinventory)
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1962: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.created_by,
1963: l_DiscreteJob_rec.created_by)
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1964: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.creation_date,
1965: l_DiscreteJob_rec.creation_date)
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1966: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_closed,
1967: l_DiscreteJob_rec.date_closed)
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1968: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_completed,
1969: l_DiscreteJob_rec.date_completed)
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1970: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.date_released,
1971: l_DiscreteJob_rec.date_released)
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1972: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.demand_class,
1973: l_DiscreteJob_rec.demand_class)
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1974: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.description,
1975: l_DiscreteJob_rec.description)
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1976: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.firm_planned_flag,
1977: l_DiscreteJob_rec.firm_planned_flag)
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1978: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.job_type,
1979: l_DiscreteJob_rec.job_type)
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1980: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.kanban_card_id,
1981: l_DiscreteJob_rec.kanban_card_id)
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1982: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_updated_by,
1983: l_DiscreteJob_rec.last_updated_by)
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1984: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_date,
1985: l_DiscreteJob_rec.last_update_date)
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1986: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.last_update_login,
1987: l_DiscreteJob_rec.last_update_login)
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1988: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.line_id,
1989: l_DiscreteJob_rec.line_id)
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1990: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.lot_number,
1991: l_DiscreteJob_rec.lot_number)
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1992: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_account,
1993: l_DiscreteJob_rec.material_account)
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
1994: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_overhead_account,
1995: l_DiscreteJob_rec.material_overhead_account)
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
1996: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.material_variance_account,
1997: l_DiscreteJob_rec.material_variance_account)
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
1998: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_net_quantity,
1999: l_DiscreteJob_rec.mps_net_quantity)
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2000: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.mps_scheduled_cpl_date,
2001: l_DiscreteJob_rec.mps_scheduled_cpl_date)
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2002: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.net_quantity,
2003: l_DiscreteJob_rec.net_quantity)
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2004: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.organization_id,
2005: l_DiscreteJob_rec.organization_id)
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2006: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_account,
2007: l_DiscreteJob_rec.osp_account)
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2008: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.osp_variance_account,
2009: l_DiscreteJob_rec.osp_variance_account)
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2010: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_type,
2011: l_DiscreteJob_rec.overcpl_tolerance_type)
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2012: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overcpl_tolerance_value,
2013: l_DiscreteJob_rec.overcpl_tolerance_value)
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2014: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_account,
2015: l_DiscreteJob_rec.overhead_account)
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2016: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.overhead_variance_account,
2017: l_DiscreteJob_rec.overhead_variance_account)
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2018: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.primary_item_id,
2019: l_DiscreteJob_rec.primary_item_id)
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2020: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_application_id,
2021: l_DiscreteJob_rec.program_application_id)
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2022: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_id,
2023: l_DiscreteJob_rec.program_id)
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2024: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.program_update_date,
2025: l_DiscreteJob_rec.program_update_date)
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2026: -- AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_costed,
2027: -- l_DiscreteJob_rec.project_costed)
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2028: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.project_id,
2029: l_DiscreteJob_rec.project_id)
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2030: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_completed,
2031: l_DiscreteJob_rec.quantity_completed)
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2032: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.quantity_scrapped,
2033: l_DiscreteJob_rec.quantity_scrapped)
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2034: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.request_id,
2035: l_DiscreteJob_rec.request_id)
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2036: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_account,
2037: l_DiscreteJob_rec.resource_account)
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2038: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.resource_variance_account,
2039: l_DiscreteJob_rec.resource_variance_account)
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2040: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_reference_id,
2041: l_DiscreteJob_rec.routing_reference_id)
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2042: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision,
2043: l_DiscreteJob_rec.routing_revision)
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2044: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.routing_revision_date,
2045: l_DiscreteJob_rec.routing_revision_date)
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2046: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_completion_date,
2047: l_DiscreteJob_rec.scheduled_completion_date)
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2048: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.scheduled_start_date,
2049: l_DiscreteJob_rec.scheduled_start_date)
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2050: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.schedule_group_id,
2051: l_DiscreteJob_rec.schedule_group_id)
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2052: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_code,
2053: l_DiscreteJob_rec.source_code)
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2054: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.source_line_id,
2055: l_DiscreteJob_rec.source_line_id)
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2056: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.start_quantity,
2057: l_DiscreteJob_rec.start_quantity)
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2058: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.status_type,
2059: l_DiscreteJob_rec.status_type)
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
2060: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.std_cost_adj_account,
2061: l_DiscreteJob_rec.std_cost_adj_account)
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
2067: l_DiscreteJob_rec.wip_supply_type)
2068: THEN
2062: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.task_id,
2063: l_DiscreteJob_rec.task_id)
2064: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_entity_id,
2065: l_DiscreteJob_rec.wip_entity_id)
2066: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec.wip_supply_type,
2067: l_DiscreteJob_rec.wip_supply_type)
2068: THEN
2069:
2070: -- Row has not changed. Set out parameter.
2141: RETURN BOOLEAN
2142: IS
2143: BEGIN
2144:
2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2143: BEGIN
2144:
2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2145: IF WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_bom_designator,
2146: p_DiscreteJob_rec2.alternate_bom_designator)
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2147: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.alternate_rout_designator,
2148: p_DiscreteJob_rec2.alternate_rout_designator)
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2149: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute1,
2150: p_DiscreteJob_rec2.attribute1)
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2151: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute10,
2152: p_DiscreteJob_rec2.attribute10)
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2153: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute11,
2154: p_DiscreteJob_rec2.attribute11)
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2155: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute12,
2156: p_DiscreteJob_rec2.attribute12)
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2157: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute13,
2158: p_DiscreteJob_rec2.attribute13)
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2159: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute14,
2160: p_DiscreteJob_rec2.attribute14)
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2161: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute15,
2162: p_DiscreteJob_rec2.attribute15)
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2163: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute2,
2164: p_DiscreteJob_rec2.attribute2)
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2165: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute3,
2166: p_DiscreteJob_rec2.attribute3)
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2167: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute4,
2168: p_DiscreteJob_rec2.attribute4)
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2169: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute5,
2170: p_DiscreteJob_rec2.attribute5)
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2171: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute6,
2172: p_DiscreteJob_rec2.attribute6)
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2173: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute7,
2174: p_DiscreteJob_rec2.attribute7)
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2175: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute8,
2176: p_DiscreteJob_rec2.attribute8)
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2177: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute9,
2178: p_DiscreteJob_rec2.attribute9)
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2179: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.attribute_category,
2180: p_DiscreteJob_rec2.attribute_category)
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2181: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_reference_id,
2182: p_DiscreteJob_rec2.bom_reference_id)
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2183: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision,
2184: p_DiscreteJob_rec2.bom_revision)
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2185: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.bom_revision_date,
2186: p_DiscreteJob_rec2.bom_revision_date)
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2187: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.build_sequence,
2188: p_DiscreteJob_rec2.build_sequence)
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2189: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.class_code,
2190: p_DiscreteJob_rec2.class_code)
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2191: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_bom_sequence_id,
2192: p_DiscreteJob_rec2.common_bom_sequence_id)
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2193: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.common_rout_sequence_id,
2194: p_DiscreteJob_rec2.common_rout_sequence_id)
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2195: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_locator_id,
2196: p_DiscreteJob_rec2.completion_locator_id)
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2197: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.completion_subinventory,
2198: p_DiscreteJob_rec2.completion_subinventory)
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2199: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.created_by,
2200: p_DiscreteJob_rec2.created_by)
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2201: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.creation_date,
2202: p_DiscreteJob_rec2.creation_date)
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2203: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_closed,
2204: p_DiscreteJob_rec2.date_closed)
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2205: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_completed,
2206: p_DiscreteJob_rec2.date_completed)
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2207: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.date_released,
2208: p_DiscreteJob_rec2.date_released)
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2209: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.demand_class,
2210: p_DiscreteJob_rec2.demand_class)
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2211: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.description,
2212: p_DiscreteJob_rec2.description)
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2213: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.firm_planned_flag,
2214: p_DiscreteJob_rec2.firm_planned_flag)
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2215: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.job_type,
2216: p_DiscreteJob_rec2.job_type)
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2217: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.kanban_card_id,
2218: p_DiscreteJob_rec2.kanban_card_id)
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2219: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_updated_by,
2220: p_DiscreteJob_rec2.last_updated_by)
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2221: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_date,
2222: p_DiscreteJob_rec2.last_update_date)
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2223: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.last_update_login,
2224: p_DiscreteJob_rec2.last_update_login)
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2225: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.line_id,
2226: p_DiscreteJob_rec2.line_id)
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2227: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.lot_number,
2228: p_DiscreteJob_rec2.lot_number)
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2229: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_account,
2230: p_DiscreteJob_rec2.material_account)
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2231: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_overhead_account,
2232: p_DiscreteJob_rec2.material_overhead_account)
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2233: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.material_variance_account,
2234: p_DiscreteJob_rec2.material_variance_account)
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2235: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_net_quantity,
2236: p_DiscreteJob_rec2.mps_net_quantity)
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2237: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.mps_scheduled_cpl_date,
2238: p_DiscreteJob_rec2.mps_scheduled_cpl_date)
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2239: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.net_quantity,
2240: p_DiscreteJob_rec2.net_quantity)
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2241: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.organization_id,
2242: p_DiscreteJob_rec2.organization_id)
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2243: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_account,
2244: p_DiscreteJob_rec2.osp_account)
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2245: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.osp_variance_account,
2246: p_DiscreteJob_rec2.osp_variance_account)
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2247: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_type,
2248: p_DiscreteJob_rec2.overcpl_tolerance_type)
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2249: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overcpl_tolerance_value,
2250: p_DiscreteJob_rec2.overcpl_tolerance_value)
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2251: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_account,
2252: p_DiscreteJob_rec2.overhead_account)
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2253: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.overhead_variance_account,
2254: p_DiscreteJob_rec2.overhead_variance_account)
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2255: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.primary_item_id,
2256: p_DiscreteJob_rec2.primary_item_id)
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2257: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_application_id,
2258: p_DiscreteJob_rec2.program_application_id)
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2259: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_id,
2260: p_DiscreteJob_rec2.program_id)
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2261: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.program_update_date,
2262: p_DiscreteJob_rec2.program_update_date)
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2263: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_costed,
2264: p_DiscreteJob_rec2.project_costed)
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2265: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.project_id,
2266: p_DiscreteJob_rec2.project_id)
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2267: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_completed,
2268: p_DiscreteJob_rec2.quantity_completed)
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2269: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.quantity_scrapped,
2270: p_DiscreteJob_rec2.quantity_scrapped)
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2271: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.request_id,
2272: p_DiscreteJob_rec2.request_id)
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2273: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_account,
2274: p_DiscreteJob_rec2.resource_account)
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2275: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.resource_variance_account,
2276: p_DiscreteJob_rec2.resource_variance_account)
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2277: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_reference_id,
2278: p_DiscreteJob_rec2.routing_reference_id)
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2279: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision,
2280: p_DiscreteJob_rec2.routing_revision)
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2281: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.routing_revision_date,
2282: p_DiscreteJob_rec2.routing_revision_date)
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2283: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_completion_date,
2284: p_DiscreteJob_rec2.scheduled_completion_date)
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2285: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.scheduled_start_date,
2286: p_DiscreteJob_rec2.scheduled_start_date)
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2287: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.schedule_group_id,
2288: p_DiscreteJob_rec2.schedule_group_id)
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2289: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_code,
2290: p_DiscreteJob_rec2.source_code)
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2291: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.source_line_id,
2292: p_DiscreteJob_rec2.source_line_id)
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2293: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.start_quantity,
2294: p_DiscreteJob_rec2.start_quantity)
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2295: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.status_type,
2296: p_DiscreteJob_rec2.status_type)
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
2297: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.std_cost_adj_account,
2298: p_DiscreteJob_rec2.std_cost_adj_account)
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
2304: p_DiscreteJob_rec2.wip_supply_type)
2305: THEN
2299: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.task_id,
2300: p_DiscreteJob_rec2.task_id)
2301: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_entity_id,
2302: p_DiscreteJob_rec2.wip_entity_id)
2303: AND WIP_GLOBALS.Equal(p_DiscreteJob_rec1.wip_supply_type,
2304: p_DiscreteJob_rec2.wip_supply_type)
2305: THEN
2306: RETURN TRUE;
2307: ELSE