eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CORE_S dependencies on PO_LOOKUP_CODES

Line 1005: table po_lookup_codes. These values are validated

1001: descriptioni VARCHAR2
1002: validate BOOLEAN
1003:
1004: ALGORITHM : Get the displayed field and description from the
1005: table po_lookup_codes. These values are validated
1006: against the inactive date if x_validate is set to TRUE
1007: No validation is performed if x_validate is set to
1008: FALSE.
1009: NOTES :

Line 1028: FROM po_lookup_codes plc

1024: SELECT plc.displayed_field,
1025: plc.description
1026: INTO x_disp_value,
1027: x_description
1028: FROM po_lookup_codes plc
1029: WHERE plc.lookup_code = x_lookup_code
1030: AND plc.lookup_type = x_lookup_type
1031: AND sysdate < nvl(plc.inactive_date,sysdate + 1);
1032:

Line 1071: table po_lookup_codes.

1067: displayed_field VARCHAR2
1068: descriptioni VARCHAR2
1069:
1070: ALGORITHM : Get the displayed field and description from the
1071: table po_lookup_codes.
1072:
1073: NOTES :
1074:
1075: =========================================================================== */

Line 1089: FROM po_lookup_codes plc

1085: SELECT plc.displayed_field,
1086: plc.description
1087: INTO x_disp_value,
1088: x_description
1089: FROM po_lookup_codes plc
1090: WHERE plc.lookup_code = x_lookup_code
1091: AND plc.lookup_type = x_lookup_type;
1092:
1093: EXCEPTION

Line 1124: ALGORITHM : Get the displayed field from the table po_lookup_codes.

1120: lookup_code VARCHAR2
1121: displayed_field VARCHAR2
1122:
1123:
1124: ALGORITHM : Get the displayed field from the table po_lookup_codes.
1125:
1126: NOTES :
1127:
1128: =========================================================================== */

Line 1141: FROM po_lookup_codes plc

1137: x_progress := 10;
1138:
1139: SELECT plc.displayed_field
1140: INTO x_disp_value
1141: FROM po_lookup_codes plc
1142: WHERE plc.lookup_code = x_lookup_code
1143: AND plc.lookup_type = x_lookup_type;
1144:
1145: EXCEPTION

Line 3800: FROM po_lookup_codes

3796:
3797:
3798: cursor C is
3799: SELECT inactive_date
3800: FROM po_lookup_codes
3801: WHERE
3802: lookup_type = p_lookup_rec.lookup_type and
3803: lookup_code = p_lookup_rec.lookup_code;
3804:

Line 3807: X_inactive_date po_lookup_codes.INACTIVE_DATE%TYPE;

3803: lookup_code = p_lookup_rec.lookup_code;
3804:
3805: X_sysdate Date := sysdate;
3806:
3807: X_inactive_date po_lookup_codes.INACTIVE_DATE%TYPE;
3808:
3809: BEGIN
3810:
3811: OPEN C;

Line 6807: -- PO_LOOKUP_CODES.displayed_field%TYPE

6803: -- Gets the text to display for the "Reserved" keyword.
6804: --Parameters:
6805: --OUT:
6806: --x_displayed_field
6807: -- PO_LOOKUP_CODES.displayed_field%TYPE
6808: -- The text corresponding to the 'RESERVED' code.
6809: --End of Comments
6810: --------------------------------------------------------------------------------
6811: PROCEDURE get_reserved_lookup(

Line 6830: FROM PO_LOOKUP_CODES POLC

6826: l_progress := '010';
6827:
6828: SELECT POLC.displayed_field
6829: INTO x_displayed_field
6830: FROM PO_LOOKUP_CODES POLC
6831: WHERE POLC.lookup_type = 'DOCUMENT STATE'
6832: AND POLC.lookup_code = 'RESERVED'
6833: ;
6834:

Line 6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;

6985:
6986: l_sep VARCHAR2(8) := ', ';
6987: l_ret_sts VARCHAR2(1);
6988:
6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;

6986: l_sep VARCHAR2(8) := ', ';
6987: l_ret_sts VARCHAR2(1);
6988:
6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;

Line 6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;

6987: l_ret_sts VARCHAR2(1);
6988:
6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;
6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;

6988:
6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;
6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
6996: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;

6989: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
6990: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;
6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
6996: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
6997:

Line 6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;

6991: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;
6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
6996: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
6997:
6998: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
6999: l_closed_code PO_HEADERS.closed_code%TYPE;

Line 6996: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;

6992: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
6993: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
6994: l_auth_status PO_HEADERS.authorization_status%TYPE;
6995: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
6996: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
6997:
6998: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
6999: l_closed_code PO_HEADERS.closed_code%TYPE;
7000: l_frozen_flag PO_HEADERS.frozen_flag%TYPE;

Line 7028: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo

7024: SELECT plc_sta.displayed_field
7025: , prh.authorization_status
7026: , DECODE(nvl(prh.closed_code,'OPEN'), 'OPEN', NULL, plc_clo.displayed_field)
7027: INTO l_status_code, l_auth_status, l_closed_status
7028: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo
7029: WHERE plc_sta.lookup_code = DECODE(prh.authorization_status,
7030: 'SYSTEM_SAVED', 'INCOMPLETE',
7031: nvl(prh.authorization_status, 'INCOMPLETE')
7032: )

Line 7044: FROM po_lookup_codes polc, po_action_history poah

7040: BEGIN
7041:
7042: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7043: INTO l_offline_status, l_offline_flag
7044: FROM po_lookup_codes polc, po_action_history poah
7045: WHERE polc.lookup_type = 'DOCUMENT STATE'
7046: AND polc.lookup_code = poah.offline_code
7047: AND poah.object_id = p_document_id
7048: AND poah.object_type_code = 'REQUISITION'

Line 7084: , po_lookup_codes plc_sta

7080: , l_closed_code
7081: , l_frozen_flag
7082: , l_user_hold_flag
7083: FROM po_headers poh
7084: , po_lookup_codes plc_sta
7085: , po_lookup_codes plc_can
7086: , po_lookup_codes plc_clo
7087: , po_lookup_codes plc_fro
7088: , po_lookup_codes plc_hld

Line 7085: , po_lookup_codes plc_can

7081: , l_frozen_flag
7082: , l_user_hold_flag
7083: FROM po_headers poh
7084: , po_lookup_codes plc_sta
7085: , po_lookup_codes plc_can
7086: , po_lookup_codes plc_clo
7087: , po_lookup_codes plc_fro
7088: , po_lookup_codes plc_hld
7089: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,

Line 7086: , po_lookup_codes plc_clo

7082: , l_user_hold_flag
7083: FROM po_headers poh
7084: , po_lookup_codes plc_sta
7085: , po_lookup_codes plc_can
7086: , po_lookup_codes plc_clo
7087: , po_lookup_codes plc_fro
7088: , po_lookup_codes plc_hld
7089: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7090: 'R', poh.approved_flag,

Line 7087: , po_lookup_codes plc_fro

7083: FROM po_headers poh
7084: , po_lookup_codes plc_sta
7085: , po_lookup_codes plc_can
7086: , po_lookup_codes plc_clo
7087: , po_lookup_codes plc_fro
7088: , po_lookup_codes plc_hld
7089: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7090: 'R', poh.approved_flag,
7091: nvl(poh.authorization_status, 'INCOMPLETE')

Line 7088: , po_lookup_codes plc_hld

7084: , po_lookup_codes plc_sta
7085: , po_lookup_codes plc_can
7086: , po_lookup_codes plc_clo
7087: , po_lookup_codes plc_fro
7088: , po_lookup_codes plc_hld
7089: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7090: 'R', poh.approved_flag,
7091: nvl(poh.authorization_status, 'INCOMPLETE')
7092: )

Line 7110: FROM po_lookup_codes polc, po_action_history poah

7106: BEGIN
7107:
7108: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7109: INTO l_offline_status, l_offline_flag
7110: FROM po_lookup_codes polc, po_action_history poah
7111: WHERE polc.lookup_type = 'DOCUMENT STATE'
7112: AND polc.lookup_code = poah.offline_code
7113: AND poah.object_id = p_document_id
7114: AND poah.object_type_code IN ('PO', 'PA')

Line 7150: , po_lookup_codes plc_sta

7146: , l_closed_code
7147: , l_frozen_flag
7148: , l_user_hold_flag
7149: FROM po_releases por
7150: , po_lookup_codes plc_sta
7151: , po_lookup_codes plc_can
7152: , po_lookup_codes plc_clo
7153: , po_lookup_codes plc_fro
7154: , po_lookup_codes plc_hld

Line 7151: , po_lookup_codes plc_can

7147: , l_frozen_flag
7148: , l_user_hold_flag
7149: FROM po_releases por
7150: , po_lookup_codes plc_sta
7151: , po_lookup_codes plc_can
7152: , po_lookup_codes plc_clo
7153: , po_lookup_codes plc_fro
7154: , po_lookup_codes plc_hld
7155: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,

Line 7152: , po_lookup_codes plc_clo

7148: , l_user_hold_flag
7149: FROM po_releases por
7150: , po_lookup_codes plc_sta
7151: , po_lookup_codes plc_can
7152: , po_lookup_codes plc_clo
7153: , po_lookup_codes plc_fro
7154: , po_lookup_codes plc_hld
7155: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7156: 'R', por.approved_flag,

Line 7153: , po_lookup_codes plc_fro

7149: FROM po_releases por
7150: , po_lookup_codes plc_sta
7151: , po_lookup_codes plc_can
7152: , po_lookup_codes plc_clo
7153: , po_lookup_codes plc_fro
7154: , po_lookup_codes plc_hld
7155: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7156: 'R', por.approved_flag,
7157: nvl(por.authorization_status, 'INCOMPLETE')

Line 7154: , po_lookup_codes plc_hld

7150: , po_lookup_codes plc_sta
7151: , po_lookup_codes plc_can
7152: , po_lookup_codes plc_clo
7153: , po_lookup_codes plc_fro
7154: , po_lookup_codes plc_hld
7155: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7156: 'R', por.approved_flag,
7157: nvl(por.authorization_status, 'INCOMPLETE')
7158: )

Line 7176: FROM po_lookup_codes polc, po_action_history poah

7172: BEGIN
7173:
7174: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7175: INTO l_offline_status, l_offline_flag
7176: FROM po_lookup_codes polc, po_action_history poah
7177: WHERE polc.lookup_type = 'DOCUMENT STATE'
7178: AND polc.lookup_code = poah.offline_code
7179: AND poah.object_id = p_document_id
7180: AND poah.object_type_code = 'RELEASE'